Archive for December, 2008

MS Excel Tips and Tricks – Hide or Unhide scroll bar

[ad#post-link]

• You can hide the vertical scroll bar or the horizontal scroll bar in any excel work book.
• Go to Tools menu
• Click Options

• The options window opens as seen above
• Just uncheck the Horizontal scroll bar to hide the Horizontal scroll bar. Check or uncheck the Vertical scroll bar to hide or unhide
• You can also hide the sheets tab by unchecking the Sheets tabs check box
• and click OK, you will see the changes in your excel
• You can make this default in all the excel workbooks that you open by editing the template file

If you have a question, please post a comment.

[ad#post-link]

MS Excel Tips and Tricks – How to insert Date and Time in Header or Footer

[ad#post-link]

You can insert Custom Headers and Custom Footers in any Microsoft Excel worksheet, so when you print, you will automatically see the custom header or footer in all the pages that you print.

• Open the Excel sheet that you want to have the date and time header or footer
• Go to View menu
• Click Header and Footer
• You will see the Page setup window opening
• Click the Custom Header if you want the date and Time to be set on top of every page
• Click the Customer Footer, if you want the date and time to be set on bottom of every page

• I am going to set this on header
• When you click on custom header, you will see one more option window opening. You have 3 areas to set up the date and time. Click left empty pane if you want to set the date and time on left. Click center or right to set it accordingly.

• Click the Date Icon to insert the Date
• Click the time icon to insert the Time
• And click OK to exit this menu
• Now lets see the print preview

• So now I have the Date and Time on every page I print from this MS Excel Sheet. You need to do this on every excel sheet that you want to have this set up.
• If you want to set it by default on all the excel that you create, you need to edit the excel template
• If you want to delete this Header and Footer
• Go to View, click Header and Footer
• Click Custom Header or Custom Footer
• Delete the Characters inside the right or center or left side of the option window
• Click ok

Read more tips and Tricks from our website

[ad#post-link]

If you have a suggestion please post a comment.