About manager

This author has not yet filled in any details.
So far manager has created 242 blog entries.

 3D Sum Formula

3D Sum formula Is it possible to easily add up the same cell across spreadsheets? By Neale Blackwood Yes, these are called 3D formulae. To create a 3D sum formula that sums all the A4 cells in multiple sheets, open a new workbook, click the AutoSum toolbar icon, then click the Sheet2 tab, then [...]

2017-03-08T03:53:56+00:00 Functions|

 Toolbar Overload

 Toolbar overload Help! I've added so many buttons to the toolbar its hard to find the one I'm after? By Neale Blackwood Two suggestions; the first is to right click the toolbar area. You will see a menu of toolbars. It's likely you don't use many of your buttons all the time. So it [...]

2017-03-08T03:53:56+00:00 Functions|

 Auto Correct Explained

Auto Correct Explained How does Excel correct my typing errors? By Neale Blackwood Excel uses AutoCorrect to correct common typing errors. To see which words are included, click the Tools menu and click AutoCorrect. Use the scroll bar to view the combination of letters and symbols that are included. You can add your own [...]

2017-03-08T03:53:57+00:00 Functions|

 Use A Range Name In A Single Sheet

Use a Range Name in a single sheet Can I create a range name that only works in a single sheet? By Neale Blackwood Yes. To create a range name that only applies to a single sheet you type in the sheet name following by a "!" then the range name you require. To [...]

2017-03-08T03:53:57+00:00 Functions|

 Dynamic Range Name

Dynamic Range Name What is a dynamic range? By Neale Blackwood A dynamic range is a range whose size changes as data is added or deleted in an area. You can use this technique to define a range for a Data Validation drop down list or define a variable length data range for a pivot table. [...]

2017-03-08T03:53:57+00:00 Functions|

 Copy Quickly Between Sheets

Copy quickly between sheets Is there a quick way to copy between sheets in the same workbook? By Neale Blackwood Open another window of the workbook by clicking the Window menu and selecting New Window. You will notice that the sheet name in the title bar will have ":2" added. To see the two [...]

2017-03-08T03:53:57+00:00 Functions|

 Pivot Tables And Grouping Dates

 Pivot Tables and grouping dates I use a pivot table to summarise a sales transaction data base. I want the data summarised by month. When I use the date to summarise the totals are by day rather than month. Is there a way to get totals by month? By Neale Blackwood There are two [...]

2017-03-08T03:53:57+00:00 Pivot Tables|

 Hiding And Unhiding Sheets

Hiding and unhiding sheets I hide a number of sheets in the workbooks I create because they are used for workings. Is there an easy way to make them all visible at once? By Neale Blackwood The following macro will unhide all the sheets in the active workbook.: Sub UnHideAllSheets() 'this macro unhides all [...]

2017-03-08T03:53:57+00:00 VBA – Macros|

 Dualing Screens

Dualing Screens I have recently upgraded to a computer with dual screens. Is it possible to display Excel across both screens and have one screen with one workbook and the other screen with another workbook? By Neale Blackwood To expand the Excel window across screens, first click the Restore Down button on the Excel [...]

2017-03-08T03:53:57+00:00 Functions|

 Cumulative Summing

Cumulative Summing I use cumulative balance columns which add the figure to the left of the cell to the value in the row above the cell. When I insert a row I have to copy the formula from the row above to the new row and to the row below for the column to [...]

2017-03-08T03:53:57+00:00 Functions|

 Save All Open Files

Save All Open Files I work with a model that has many files and links between the files. When I make structural changes that affect links I have to go through and save all the open files to make sure the changes are kept. Is there a way to save all the open files [...]

2017-03-08T03:53:57+00:00 VBA – Macros|