Here's a list of some really little things that you can use in Excel that can add up to big savings in time at the end of the day. They are in no particular order. Enjoy.
- Double-click in a cell to edit the contents - no need to go up to the Formula Bar to edit.
- Double-click a sheet tab to rename it then press the Enter key.
- Tap the F4 (function 4) key to create an absolute reference in a formula. Tapping it again will cycle through mixed references (where only one $ appears) and then back to relative reference (where no $ appear).
- Rearrange sheets by dragging the sheet tab left or right. A small triangle moves with your mouse showing the new position of the moved sheet.
- Change the color of a tab by right clicking (Ctrl click on Apple) and choosing your favorite color.
- Duplicate a sheet by holding down the Ctrl key and dragging the sheet tab to the left or right. This duplicates not only the contents but all of the print, orientation, margin, header & footer settings, infinitely superior to copy and paste.
- Use the group edit to make the same change to multiple sheet at the same time. To get into the group edit, click on one sheet, hold down the Ctrl key and click on additional sheets. To get out of the group edit click on any sheet tab that is not part of the group. This is a BIG time saver if you are adding an entry or a row/column to multiple sheets.BONUS: If you use the print command while in the group edit all of the sheets in the group will print.
- Double-click on the vertical line between the column letters at the top of the column to adjust the column width to "best fit", no need to drag and guess how wide the column should be.
- Press the Esc key to get rid of the marque (dancing ants) around copied cells. This also empties the computer's clipboard.
- When you use the filter command (on the Home tab, Editing group) you will not only be able to sort and filter the columns by alpha and numeric contents but you will have color as an option for sorting and filtering. This assumes that you have formatted cells with color.
courtesy : http://bnjho.blogspot.in
0 comments:
Post a Comment