TRANSPOSE Function in Excel

Post author:Neale Blackwood
Post published:16/08/2016
Post category:Functions Tips & Tricks
Post comments:1 Comment

The TRANSPOSE function is one of only a few functions that must be entered as an the array using keyboard entry Ctrl + Shift + Enter (CSE). It allows you to switch a range from going across the sheet, to go down the sheet and vice versa.

(more…)

Populating Blank Cells in Excel

Post author:Neale Blackwood
Post published:26/07/2016
Post category:Data Excel Blog Macros
Post comments:0 Comments

I have mentioned before that blank cells in your data can affect Pivot Table defaults in Excel. They can also reduce the effectiveness of some keyboard and mouse shortcuts. The macro below populates blank cells in the selected range with zeros.

(more…)

End of content

No more pages to load