Tag: excel vba
Excel Example – Transpose in Excel
The 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function. Transposing...
Excel Example – AutoFit in Excel
What is AutoFit in Excel?
AutoFit in Excel is a feature that automatically adjusts the width of columns or the height of rows to fit...
Excel Example – Skip Blanks in Excel
Use the 'Paste Special Skip Blanks' option and Excel will not overwrite existing values with blanks. Often, you'll encounter situations where you want to...
Excel Example – Hide Columns or Rows in Excel
Hide Columns or Rows
Sometimes it can be useful to hide columns or rows in Excel. Learn how to hide a column, unhide all columns,...
Excel Example – Custom Lists in Excel
Custom Lists
If you create a custom lists in Excel, you can easily fill a range with your own list of departments, clients, cities, credit...
Excel Example – Fibonacci Sequence in Excel
Fibonacci Sequence
The Fibonacci sequence is one of the most famous and fascinating mathematical patterns. It begins with 0 and 1, and each subsequent number...