Archive for December 14th, 2008

Ms Excel Tips and Tricks Hide or Unhide Excel workbook

• You can hide any Microsoft excel workbook or sheets.
• To hide a work book open the work book
• Click Window menu
• Click hide

[ad#post-link]

• The current workbook will be hidden from the view
• When you close the MS Excel, If you have not saved the excel work book earlier, you will be prompted for the ms excel to be saved
• You can find the Ms excel in the same folder but when you open you will not see any content
• If you want to unhide a work book, open the MS excel and go to Windows menu and click Unhide

• Ms Excel will ask you which one of the hidden files that you want to open
• Choose the file that you want to open

Read more about Microsoft excel tips and tricks from our website

[ad#post-link]

MS-Excel Tips and Tricks – Change the Gridline color

Microsoft excel gridline are the ones that are around the cell in Grey color. By default excel has the grey color as the cell gridline border color.

You can change the Excel gridline color of a MS excel sheet by following the methods below.

• Open MS Excel
• Go to Tool
• Click Options
• You will see the small options windows opening as seen below

• At the bottom of the excel options window you will see Window Options
• You will also se Gridlines color
• Choose the color that you want and click OK

• Now you will see the MS excel gridline colors change to the new one that you have selected

Remember this is only applicable to one sheet that you select, if you want this gridline color change in all the Excel sheet in a work book, Group them before changing the color. To group all the sheet, hold shift key and click the first sheet then the last sheet.

To ungroup, right click on any excel sheet tab and select Ungroup

If you want this gridline color to affect all the excel workbook, you need to change the template.

This is applicable to MS Excel 2003 and Excel 2007.

Read more excel tips and tricks from our website