TechTalk & Personal Computing Guide


TechTalk & Personal Computing Guide
TechTalk & Personal Computing Guide

Excel's Hidden Tricks - part 1

cdesai12 Goldie

Joined: 18 September 2004
Posts: 1900

Posted: 12 January 2005 at 10:25pm | IP Logged

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.


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 your worksheet.


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 created.

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



nandiinii Senior Member

Joined: 01 November 2004
Posts: 503

Posted: 13 January 2005 at 8:08am | IP Logged
very nice info..thanks!!Smile
HUMM IF-Dazzler

Joined: 06 November 2004
Posts: 2927

Posted: 13 January 2005 at 12:00pm | IP Logged
Thanks buddy... hmmm ur smartWink
  • Page 1 of 1

Go to top

Related Topics

  Topics Author Replies Views Last Post
Hidden Files in Windows Explorer

Author: meghavi   Replies: 3   Views: 1082

meghavi 3 1082 19 January 2005 at 2:09pm by SONYA_K

Forum Quick Jump

Forum Category / Channels

  • Please login to check your Last 10 Topics posted

Disclaimer: All Logos and Pictures of various Channels, Shows, Artistes, Media Houses, Companies, Brands etc. belong to their respective owners, and are used to merely visually identify the Channels, Shows, Companies, Brands, etc. to the viewer. Incase of any issue please contact the webmaster.

Popular Channels :
Star Plus | Zee TV | Sony TV | Colors TV | SAB TV | Life OK

Quick Links :
Top 100 TV Celebrities | Top 100 Bollywood Celebs | About Us | Contact Us | Advertise | Forum Index