Excel: Chapter 1: Lesson 11 - Flash Fill
Use flash fill in Excel 2013 or later to automatically extract or to automatically combine…
Showing posts with the label Excel
Excel: Chapter 1: Lesson 10 - Union and Intersect
B2B
This example illustrates how to use the union and intersect operator (borders below for il…
Excel: Chapter 1: Lesson 9 - Transpose
B2B
Use the ' Paste Special Transpose ' option to switch rows to columns or columns to row…
Exce: Chapter 1: Lesson 8 - AutoFit
B2B
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
B2B
Use the ' Paste Special Skip Blanks ' option and Excel will not overwrite existing v…
Excel: Chapter 1: Lesson 6 - Hide/Unhide Columns or Rows
B2B
Sometimes it can be useful to hide columns or rows in Excel . Hide To hide a column, …
Excel: Chapter 1 : Lesson 5 - Comments
B2B
You can insert a comment in Excel to give feedback about the content of a cell. Insert C…