Recent Webinar Feedback
I received this email from someone who isn't in my typical webinar audience of accountants and finance staff. They had attended the first of the Beginners live sessions.
Clearing Unlocked Cells in Excel
People always ask, how to do you lock Excel? In fact you have to unlock Excel and then protect the sheet. The default setting for all cells is locked, so you need to unlock input cells.
(more…)Page Breaks in Excel
When you set your print area or use the Page Break Preview View, Excel will show you the page breaks on the grid. If this annoys or distracts you, here is how to remove them. It’s a one-line macro that turns off the page breaks in the current sheet. Sub TurnOffPageBreaks() ActiveSheet.DisplayPageBreaks = False End Sub If you are new to macros then this blog post can take you through how to use them. The above code can be copied…
One Minute to Excel #16 – Create a useful macro
The Merge cells format has lots of issues. It can crash macros and stop you copying and pasting.
In less than a minute you can use a macro to solve the problem.
(more…)