You can store different values for the same worksheet cells without making multiple copies of the file. Choose Scenarios from the Tools menu.
You can share files with users of older versions of Microsoft Excel by using the Save As command on the File menu to save ...
You can sort data based on a custom sort order that you define. To define one, choose Preferences from the Edit menu, and ...
You can specify how many sheets you want in each new workbook. Choose Preferences from the Edit menu, select the General ...
You can specify rows or columns to be repeated on every printed page. Choose Page Setup from the File menu, and then specify ...
You can store different values for the same worksheet cells without making multiple copies of the file. Choose Scenarios ...
You can suppress the display of positive, negative or zero values by creating a custom number format in which the appropriate ...
You can transpose rows and columns in a selected range. Copy the range, select a single cell, choose Paste Special from the ...
You can type an asterisk (*) in the Find What box to match any number of characters or a question mark (?) to match any single ...
You can use an ampersand (&) to concatenate text strings in a formula. For example, if A1 contains 'week' and A2 contains ...