Posted: 12 January 2005 at 10:25pm | IP Logged
BUTTONS NOT ALL THEY SEEM TO BE
While most toolbar buttons do exactly what they promise to do when you click
them, a few of them have alternate personalities. These buttons perform a
different task when you hold the Shift key when clicking on them. Here are the
buttons that change behaviour and what they change to do:
Shift + Open becomes Save As
Shift + Save becomes Open
Shift + Print becomes Print Preview
Shift + Print Preview becomes Print
Shift + Sort Ascending becomes Sort Descending
Shift + Sort Descending becomes Sort Ascending
Shift + Underline becomes Double Underline
Shift + Double Underline becomes Underline
In theory, at least, if toolbar space is at a premium, you could remove one of
each pair of buttons and use one button for two tasks.
NEW MENU OPTIONS
There are some added tricks you can perform with the Shift key and some Excel
menus. For example, if you hold Shift when opening the File menu you may notice
that the Close option has been replaced with a Close All option allowing you to
close all open worksheets in one command.
This also works in Word - hold down the Shift key then click on the File menu to
see Save and Close change to Save All and Close All.
Tip: you have to press Shift before choosing the File menu - if you display the
menu first it won't change labels/action when you press the Shift key.
Hold the Shift key down as you open the Edit menu and some very different
options appear. One of these, Copy Picture, lets you copy the currently selected
cells or chart or image as a picture and later paste it back as an image into
RIGHT DRAG FILL
You probably already know that you can fill a range of cells using one or two
cells as a seed value. For example, type Jan in a cell and click in the cell
then drag the indicator in its bottom right corner to the left or down to fill
the selected range with the months of the year. You can create a sequence of
numbers 1, 2, 3 etc by typing 1 and 2 in two adjacent cells, select them, then
drag the fill handle. Something different happens when you type 1 in a cell and
drag its fill handle - the range is filled with the number 1 and no sequence is
However, the situation alters if you drag with the right mouse button rather
than the left. In this case one of the options is Fill Series which creates a
numerical series from the starter value. If you type 1 and 2 in adjacent cells,
select them and then right mouse drag the fill button you can choose to copy the
cells which results in a 1, 2, 1, 2, 1, 2, 1 etc. sequence.
While entering a date in a cell and dragging the fill handle fills the range
with sequential dates, using the right mouse button lets you choose to Fill
Weekdays so you don't enter weekend dates. Alternately you can choose to Fill
Months or Fill Years to create different date sequences
STAY TUNE FOR PART 2......
I AM WORKING ON IT.....