Read more

View all

Excel: Chapter 1: Lesson 11 - Flash Fill

Use  flash fill  in  Excel  2013 or later to automatically extract or to automatically combine…

Excel: Chapter 1: Lesson 10 - Union and Intersect

This example illustrates how to use the  union  and  intersect  operator (borders below for il…

Excel: Chapter 1: Lesson 9 - Transpose

Use the ' Paste Special Transpose ' option to switch rows to columns or columns to row…

Exce: Chapter 1: Lesson 8 - AutoFit

You probably know how to change the width of a column in  Excel , but do you also know how to …

Excel: Chapter 1: Lesson 7 - Skip Blanks

Use the ' Paste Special Skip Blanks ' option and  Excel  will not overwrite existing v…

Excel: Chapter 1: Lesson 6 - Hide/Unhide Columns or Rows

Sometimes it can be useful to  hide columns  or  rows  in  Excel . Hide To hide a column, …

Excel: Chapter 1 : Lesson 5 - Comments

You can insert a  comment  in  Excel  to give feedback about the content of a cell. Insert C…

Load More That is All