Hiding Cell Contents from the Printer !

Need to produce a printout where certain cells (not an entire row or column, you could right-click and Hide them) in the print area need to be hidden?


One trick is to set the font color in those cells to white.

1. Select the cell(s)
2. Format | Cells
3. In the Format Cells dialog box click the Font tab
4. Click the arrow at the right side of the Color list box and select white from the list
5. Click OK to close the dialog box and apply your new font color
6. Print the worksheet without showing the unwanted cells. After you finish printing, select the cells again and set the color back to black (or automatic).

Best Regards,

Moving Sheet to Sheet, Window to Window !

Is there a shortcut key for switching between sheets (and windows) in an Excel spreadsheet/workbook?

Yes there is:

• To move to the next sheet in a workbook, press Ctrl + PgDn.
• To move to the previous sheet in a workbook, press Ctrl + PgUp.
• To move to the next window (open workbook), press Ctrl + Tab.

More tips will be shared soon.

Best Regards,

Logic for Number Formatting Keyboard Shortcuts !

At times keyboard shortcuts seem random, but there is logic behind them. To format a number as a currency the shortcut is CRTL + SHIFT + 4.

Both the SHIFT and 4 keys seem random, but they're intentionally used because SHIFT + 4 is the dollar sign ($). Therefore if we want to format as a currency, it's simply: CTRL + ‘$' (where the dollar sign is SHIFT + 4). The same is true for formatting a number as a percent.

Best Regards,

Repeat Command !

If you want to repeat the last thing you did, just hit

ctrl + y

or

press F4,


It will repeat the last format thing you done on the previous cell.

Stay tuned for more shortcuts.


Best Regards,

Sign Shortcut keys !

SIGN SHORTCUT KEYS !

Alt	+	153	=	™	trademark symbol
Alt	+	169	=	©	copyright symbol
Alt	+	174	=	®	registered trademark symbol
Alt	+	176	=	°	degre­e symbol
Alt	+	177	=	±	plus-or­-minus sign
Alt	+	182	=	¶	paragraph mark
Alt	+	190	=	¾	fractio­n, three-fourths
Alt	+	215	=	×	multi­plication sign
Alt	+	162	=	¢	the cent sign
Alt	+	161	=	¡	upside down exclamation point
Alt	+	191	=	¿	upside down question mark
Alt	+	1	=	☺	smiley face
Alt	+	2	=	☻	bla­ck smiley face
Alt	+	15	=	☼	su­n
Alt	+	12	=	♀	female sign
Alt	+	11	=	♂	m­ale sign
Alt	+	6	=	♠	s­pade
Alt	+	5	=	♣	Club
Alt	+	3	=	♥	Heart
Alt	+	4	=	♦	Diamond
Alt	+	13	=	♪	e­ighth note
Alt	+	14	=	♫	beamed eighth note
Alt	+	8721	=	∑	N-ary summation (auto sum)
Alt	+	251	=	√	s­quare root check mark
Alt	+	8236	=	∞	infinity
Alt	+	24	=	↑	up arrow
Alt	+	25	=	↓	down arrow
Alt	+	26	=	→	i­ght arrow
Alt	+	27	=	←	l­eft arrow
Alt	+	18	=	↕	u­p/down arrow
Alt	+	29	=	↔	left right arrow

Your comments and suggestion will be highly appreciated.

Keep visiting for more tips and shortcut keys.

Best Regards,

Reduce Auto save Time to 1 Minute in Excel !

Hello Guys, its my first post, so i will start with a little basics.

I will tell you how to change the setting of auto save from 10 minutes to 1 minutes.

For changing the auto save time, follow the below mention steps.

• Go to File.

• Click on Options.

• A new window will pop-up. On which you can see the option of Save.

• After clicking on save you can see an option showing the save time. Click on the arrows against the time to increase or decrease your save time. Don't forget to click on OK after changing the time.

There it is. You have adjusted your auto save time as per your requirement.

Stay in touch with the blog, more interesting excels tips will be shared soon.

Best Regards,