How to Generate A List of All The Sheets In A Excel Workbook

Start with a workbook that has lots of worksheets or chart sheets. Then follow these steps to create a list of the sheet names: 1. Insert a new worksheet to hold the list of sheet names. 2. Choose Formulas➜Define Name to display the New Name dialog box. 3. Type SheetList...

Read More

How to Retrieve A List of Filenames in A Folder and Display Them in A Excel Worksheet

This technique uses an Excel 4 XLM macro function in a named formula. It’s useful because it’s a relatively simple way of getting a list of filenames into a worksheet — something that normally requires a complex VBA macro. Start with a new workbook and then follow these...

Read More

How to Forcing a Protected View Excel File to Open in Normal View

If you download a workbook and you’re absolutely certain that it’s safe, you can force it to open in Normal view. Here is the trick : Right-click the workbook name (or icon) and choose Properties from the shortcut menu. The Properties dialog box appears. Click the General...

Read More

How to Customize the Ribbon in MS Excel

You customize the Ribbon in the Customize Ribbon tab of the Excel Options dialog box . The quickest way to display this dialog box is to right-click anywhere in the Ribbon and choose Customize the Ribbon. Customizing the Ribbon is very similar to customizing the Quick...

Read More

How to Customizing the Quick Access Toolbar in MS Excel

If you find that you continually need to switch Ribbon tabs because a frequently used command never seems to be on the Ribbon that’s displayed, this tip is for you. The Quick Access toolbar is always visible, regardless of which Ribbon tab is selected. After you customize the...

Read More

How to Change MS Excel Themes

1. Click File 2. Click Option 3. At the office theme options, choose the theme you want applied to MS excel 4. Click Ok button ...

Read More

How to Inserting a Watermark in MS Excel

A watermark is an image or text that appears on a printed page. A watermark can be a faint company logo or a word, such as DRAFT. Excel doesn’t have an official command to print a watermark, but you can add a watermark by inserting a picture in the page header or footer. Here’s...

Read More