Here is a quick tip to select the entire workbook with just one click. The next time you need to select an entire worksheet, click the little gray box in the top-left corner of the sheet.
What are some of the reasons why you would want to select an entire worksheet?
1. With the entire worksheet selected, you can copy it from one
workbook and then paste it into another worksheet. By selecting
the whole worksheet it ensures that you won’t accidentally miss
something.
2. With the entire worksheet selected, you can quickly and easily
change the font in all cells or apply formatting to all cells.
3. With the entire worksheet selected, you can double-click on
any line separating two column letters or the line separating
any two rows to adjust the width of the columns or the height
of the rows.
Subscribe to:
Post Comments (Atom)
This tip works in 2003 also. Another very important use is that before you sort data you need to select every cell of data. If you don't, your data will be jumbled during the sort. And, regretfully, Undo doesn't work after a sort.
ReplyDelete