Changing the number of recently opened documents in Excel main menu.

The default number of recently opened documents in Excel main menu is 10 However, when often open and close the same workbooks, this amount may be insufficient. This can be very easily modified by changing the some Excel settings. To … Continue reading

AutoRecover in Excel 2007

When working with Excel documents (or any other files) you should be protected from losing all the work in case of power loss, computer crash or other unspecified reasons, which may ends that you have to start all over again. … Continue reading

Hide / unhide a worksheet in Microsoft Excel 2007 workbook

In order to protect a worksheet against unauthorized access or from accidental modification, you can hide it. This can be done in a very simple way: click the right mouse button on the worksheet tab you want hide(for example, Sheet1, … Continue reading