Excel – Paste a link and Paste Special transpose your data
Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel. Linking information from one cell to another saves…
-
-
Excel – How do I sum a range of cells that include #N/A or #DIV/0! errors?
Most of us will agree that error values can be helpful and sometimes extremely unhelpful. For example, the #N/A (Value Not Available)…
-
Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging
PROBLEM: retaining a leading 0 (zero) when entering Post Codes. When you enter a post code that has a leading 0 (zero), e.g….
-
Excel – How do I merge cells within a range that is formatted as a Table?
Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…
-
How to create a list of Working Days – Excel WORKDAY function
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays or workdays only? Let’s look…
