Tips and other useful information
A collection of useful excel related tips and frequently asked questions-
Office Icons
-
Print codes for formatting headers and footers
-
Setting custom error bar values via VBA in xl2007
-
Setting data marker transparency via VBA in xl2007
-
Removing automatic chart title via VBA in xl2007
-
Shape Adjustment in xl2007
-
Linking the chart title to a cell
-
Make X axis labels display below negative data
-
Selecting chart elements using the cursor keys
-
Changing name of embedded chart
-
Displaying Y axis values on both sides of plot area
-
Displaying Y axis values on the right of the plot area
-
Plotting bar chart categories in reverse order
-
Displaying the secondary X axis
-
Line chart marker variations
-
Installing Add-In xl2007
-
Mimic 2007 Conditional Formatting Icons
-
Features deprecated in xl2007