08 6210 8500
Drag letters the same as numbers Is it possible to have Excel increment the letters of the alphabet in the same way it increments numbers, when you drag the fill handle? By Neale Blackwood Yes, Excel's Custom List feature will allow you to do that. The easiest way to create a Custom list is [...]
REPT function - create a Cell chart Is it possible to use a cell to display a bar indicator like a bar chart, based on another cell's value? By Neale Blackwood The REPT function allows you to repeat a character a defined number of times. If cell A1 contained 65, the following formula [...]
Alt + Enter = Insert a line in a cell Keyboard Shortcut By Neale Blackwood To insert a line within a cell hold the Alt key (next to your space bar) and press Enter. This inserts a fixed line break in the cell. This operates differently to the Wrap Text format. Wrap [...]
F4 key - Repeat last action and add $ signs Keyboard Shortcut By Neale Blackwood The F4 function key has a dual personality. When used normally it will repeat your last action. This is useful for formatting, deleting rows and other operations that require a few keystrokes. Pressing F4 can reduce the keystrokes. Its [...]
Easy and Quick Formatting Format Painter By Neale Blackwood One of the more useful toolbar icons is the Format Painter. It looks like a yellow paintbrush. It allows you to click on a cell that has a format you want to use and then click the Format Painter (notice that the mouse cursor shape [...]
Organisation Chart Built-in feature By Neale Blackwood Ever needed to create an Organisation Chart but don't have Visio? Have a look at Excel's built-in Org Chart creator. Click Insert menu > Diagrams and select the Org Chart. Use the drop downs on the toolbar to add to the chart. The AutoFormat button has a [...]
Enter values in multiple cells Ctrl + Enter By Neale Blackwood Ever wanted to enter the same value, say zero, into a range in one go? Ever wanted to enter a formula into a range in one step? Well Ctrl + Enter will do it. Select a range, preferably a blank range. Type 0, [...]
See All Menu Options Built-in feature By Neale Blackwood One of the more frustrating features of Excel 2003 is that the default setting for the menu display is set to "Show full menus after a short delay". With this setting Excel only displays the menu items that have been chosen in the past and [...]
Do not pass Go To F5 Function key By Neale Blackwood Pressing F5 or Ctrl + g opens the Go To dialog. Using the Go To feature has a number of advantages. The first is you can press F5 followed by Enter to return after following a hyperlink. This also works if you have [...]
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
Dragging weekdays only Right click and drag By Neale Blackwood If you need to populate only weekdays when you drag a date cell with the fill handle (the cross at the bottom right corner of cell/range) then drag the fill handle with the right mouse button. When you release the button there will be [...]
Expand the Formula Bar Excel 2007 only By Neale Blackwood New in Excel 2007, you can make the Formula Bar higher. Between the column letters and the Formula Bar there is a line. If you point to the line Excel displays a double-headed arrow. You can click, hold and drag the line down to [...]
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