If you have a workbook with a number of worksheets, some visible and other hidden, and you want to print only the hidden sheets, then you can use the macro shown below.
Because Excel will not allow the macro to be printed while it is hidden, this macro will make the sheet visible, print it and [...]
The autofilter feature in Excel allows you to show a subset of your data based on a specified criteria. The top 10 is such a criteria.
To show only the top 10 values (or any other number) for a particular column follow these steps :
1. Click Data –> Filter –> Autofilter.
2. In the column which have [...]
The SUMIF function is a direct way to sum values based on a single criteria. If we want to sum or add values based on multiple criteria however, then we need to take extra steps. One alternative for this is to use the SUM function and the IF function.
In the example below we want to [...]
If you want the number of months occurring regardless of the day of the month then continue reading. If you want to calculate ‘whole month intervals’ by considering the day of the month, then check this post.
To calculate the number of months between two dates, there are two possibilities:
1. Both dates occur in the same [...]
To calculate the difference or the number of days between two dates, you simply subtract one date from the other.
Example (using format:dd/mm/yyyy):
Suppose you have the date 25/11/2007 in cell A1 and the date 15/01/2008 in cell B1 (both cells formatted as date). To calculate the difference between these two dates you use the following formula:
=B1 [...]
To sum values based on a specified criteria or condition you use the SUMIF function, and its syntax is as follows:
SUMIF(range,criteria,sum_range)
Range is the range of cells that you want to be evaluated using the specified criteria.
Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added [...]
If you have a workbook with a considerable number of worksheets, some visible and other hidden, and you want to print only the visible sheets, then you can use this macro:
Sub PrintVisibleSheets()
‘***************************************************
‘Print only visible sheets in the active workbook [...]
One of the options in the Data menu is the Subtotals. It allows you to create subtotals for a specific column in your worksheet, based on a key in another column. The subtotals will be added to the original data which will be retained as it is.
The best way to explain how to create a [...]
To print all worksheets in a workbook then :
1. In the File menu click Print.
2. The Print window will open.
3. At the bottom of the Print window find a section labeled: Print what .
4. Click on the radio button labeled: Entire workbook.
5. Click OK.
Applies to Excel 2003
To copy or move worksheets within the same workbook follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. The To book drop down will default to the current workbook. Leave this as [...]
