View multiple sheets or workbooks at the same
time
- Open the workbooks you want to view.
To view multiple sheets in the active workbook,
click New Window on the Window menu. Switch to the new window, and
then click a sheet you want to view. Repeat for each sheet you want to view.
- On the Window menu, click Arrange.
- Under Arrange, click the option you want.
To view sheets in only the active workbook, select
the Windows of active workbook check box.
Put Today’s Date on your Spreadsheet
In the cell where you want today’s date, just type =NOW()
If the result doesn’t look like a date, it may need formatting. Go to Format, Cells, then on the Number tab choose Date,
then choose the desired date format and click OK
Display all of your Sheet Names in Excel
In Excel when you have many worksheets and you have trouble seeing all the sheet tabs, sheet navigation can be difficult. To
display the entire sheet names:
Right-Click on the sheet navigation buttons to the left of the Sheet Tabs. A list of all sheet names will be displayed. If
there are more sheets than can be properly displayed on the screen, then click on "see more sheets", and a dialog box will be
displayed showing an alphabetic list of all worksheets.
Quickly Select an Entire Range of Cells
To quickly select all the cells surrounding your cursor, press CTRL + SHIFT + *
Selecting beyond what you see
When you select multiple rows or columns does your mouse go zing out of control and select too much? Try this:
- Put your cursor in the upper left corner
- Press the F8 function key
- Move to the bottom right corner any method you like – scrolling works great and then just click.
While you move around you will see the selection extending. The F8 key works like a toggle and puts an EXT code in the status
bar next to NUM.
If you wish to voice your opinion, or wish to be removed from our mailing list, please click
here. It is not our
intent to annoy anyone – We’re here to assist you in any way we can. Please let us know how we’re doing.
|
