INTHEBLACK February 2022 - Magazine - Page 73
CLICK HERE TO ACCESS
Extra material, a podcast
and a video from
Neale Blackwood CPA
Neale Blackwood CPA runs A4 Accounting,
providing Excel training, webinars and consulting
services. Questions can be sent to a4@iinet.net.au
03
04
06
05
07
unhide rows and the data changes, then the
visible and hidden rows captured by a custom
view may no longer be valid.
Custom views are useful for capturing which
sheets are hidden and which are visible at a
point in time, and a custom view can quickly
reinstate the hidden and visible sheets. The
limitation is that sheets added after the custom
view is created will not be included in the
custom view settings.
Custom views cannot be edited. If changes
are introduced after a custom view has been
created, you will need to delete the old
custom view and then re-create it to handle
the new structures. Custom views are easy to
create and use. If your file structure doesn’t
change much, custom views can be useful.
Their limitations do reduce their practical
long-term use in many cases. The companion
video to this article will take you through
creating and using a custom view.
UNHIDING SHEETS
In the most recent versions of Excel, you can
unhide multiple sheets by right-clicking a sheet
tab and choosing Unhide.
You can use the Shift key or the Ctrl key to
select multiple sheets to unhide, then click
OK. In the older versions, you can only unhide
one sheet at a time and custom views may be
the best option to speed up unhiding/hiding
multiple sheets in one step.
E XC E L P R I N T I N G T I P S
Set your print area (Page Layout
ribbon) to limit and control what range
will be printed.
Always check the Print screen (File tab)
before printing for the first time. Check
the number of pages and the page breaks.
Use the built-in options on the Print
screen (File tab) to save some time.
Some useful options are
Orientation – Portrait or Landscape
Custom Margins – there is a Narrow option
Scaling – Fit Sheet to One Page
– Fit All Columns on One Page
intheblack.com February 2022 73