Currently viewing the category: "Excel"

Remove page breaks from your report.

  1. Click anywhere on your tablix.
  2. Right click on any of the gray row or column headers.
  3. Click on Tablix Properties.
  4. Remove page breaks by unckecking the page break boxes.

image

Credits (Excel 2000)
1. Open up a blank excel sheet.
2. Press F5.
3. Type x2000:L2000 and press enter.
4. Press tab once so that you are in column M.
5. Hold control and shift then right click on the Bar Graph icon at the top of the screen.


Easter Egg (Excel 2000)
1. Open Excel 2000.
2. Under file menu, click on “Save as Web Page.”
3. Click on “Publish Sheet” and “Add Interactivity.”
4. Save file.
5. Open the htm file with Internet Explorer.
6. Scroll to row 2000 and column WC.
7. Select row 2000, and tab so that WC is the active column.
8. Hold down Shift+Ctrl+Alt and click the Office logo in the upper-left.


Flight to Credits (Excel 97)
1. On a new Worksheet, press F5.
2. Type X97:L97 and press enter.
3. Press the tab key.
4. Hold Ctrl-Shift.
5. Click on the Chart Wizard toolbar button.


Hall of Tortured Souls (Excel 95)
1. Open Excel 95 with a blank worksheet.
2. Go to row 95.
3. Select the whole row.
4. Tab over to column B.
5. Go to Help/About.
6. Hold down Shift+Ctrl+Alt and click on the Technical Support button.
7. A window appears call “Hall of Tortured souls.”
8. At the end of the hall you will find the programmer names.
9. Make a 180 degree turn and type excelkfa.


Dot Matrix Credits Display (Excel 5.0)
1. Begin with a new worksheet displaying the standard toolbar.
2. Using the mouse, right click on the toolbar.
3. Choose Customize.
4. Under Categories scroll to Custom.
5. Click and drag the Solitaire icon to the toolbar.
6. When the Assign to Macro window comes up, click OK.
7. Close the Customize window.
8. Press and hold Shift+Ctrl+Alt, then left click on the solitaire icon.