08 6210 8500
Pasting Values made easy I use Edit > Paste Special > Values frequently and was wondering, what is the easiest way to do it? By Neale Blackwood The easiest way to paste values is by dragging the range or cell with your right mouse button. When you release the button the menu has 'Copy [...]
Using Text Boxes on Charts I use text boxes to put notes onto charts. But if I move the chart the text boxes don't move with it. Is there an easy way to achieve this? By Neale Blackwood There are a couple of solutions to this problem. The first uses the Ctrl key to [...]
Follow link by double clicking I've used spreadsheets that let you follow a link in a cell by double-clicking on the cell, but I can't find the setting that makes this work. What setting do I have to change? By Neale Blackwood The setting you need to change is named after another feature, which [...]
Hiding cell contents I use the white font colour to hide values in a cell, but if the cell's fill colour is changed, it displays the entries. If you select the cells you can also see them. If Black and White is selected in Page Setup the entry will print. Is it possible to [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Counting non-blank cells I have a range of IF functions that return "" in certain circumstances. I want to count the number of cells without "", but COUNTIF won't do it. Is there a way to count the non-blank cells in the range? By Neale Blackwood The SUMPRODUCT function can count non-blanks. Assuming the [...]
Fix for missing Fill Colours Excel won't display the cell's fill colours. The colour is there when I print out, but it doesn't display on the screen. The file is OK when I view it on another computer. Is there a setting I need to change? By Neale Blackwood You need to change a [...]
Lining up charts and other graphics Is there an easy way to position charts so that they line up exactly on the left-hand side? By Neale Blackwood If you hold down the Alt key (next to the space bar) when you move the chart around you will see that it snaps to the cell [...]
Print all sheets in one step Is it possible to print all the sheets in a workbook in one step? By Neale Blackwood To print all the sheets, right click any of the sheet tabs and choose Select All Sheets. Then click the print button. As a precaution you should first click the Print [...]
Change print page to A4 We receive worksheets from other divisions that have the paper size set to Letter. This affects how the pages print out on A4 paper. Is there an easy way to convert all the sheets in a workbook to the A4 paper size? By Neale Blackwood The macro below will [...]
Enter & symbol in the Header or Footer How do you print the & (ampersand) character in the Header? By Neale Blackwood The & character is used to define certain information that can be printed in Headers and Footers. To print the & character itself use &&. Hence, if you want to print Smith [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Pay my invoice