top of page
Search
![](https://i.ytimg.com/vi/JWPltunDkdw/maxresdefault.jpg)
![Sort by Custom Color List](https://i.ytimg.com/vi/JWPltunDkdw/maxresdefault.jpg)
Spreadsheet Nation
Oct 6, 20211 min read
Sort by Custom Color List
Sort you data by multiple colors.
49 views0 comments
![](https://i.ytimg.com/vi/48rMArR19J0/maxresdefault.jpg)
![Dynamic Drop-Down List](https://i.ytimg.com/vi/48rMArR19J0/maxresdefault.jpg)
Spreadsheet Nation
Oct 2, 20211 min read
Dynamic Drop-Down List
Create a drop-down list that changes.
90 views0 comments
![Custom Sort](https://static.wixstatic.com/media/749de7_b2dba5cc5e33442ba6eae8646b1ea1ac~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_b2dba5cc5e33442ba6eae8646b1ea1ac~mv2.webp)
Spreadsheet Nation
Apr 29, 20201 min read
Custom Sort
Learn how to create a custom sort for your data.
32 views0 comments
![Date Formats in Excel](https://static.wixstatic.com/media/749de7_d37ed8e97d534403ad5d3b3902320cf0~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_d37ed8e97d534403ad5d3b3902320cf0~mv2.webp)
Spreadsheet Nation
Mar 7, 20201 min read
Date Formats in Excel
Display the date in different ways in Excel.
32 views0 comments
![MID Function](https://static.wixstatic.com/media/749de7_3b4782bad87c473e9128e4b424f9e9a1~mv2.png/v1/fill/w_454,h_235,fp_0.50_0.50,q_95,enc_auto/749de7_3b4782bad87c473e9128e4b424f9e9a1~mv2.webp)
Spreadsheet Nation
Nov 15, 20191 min read
MID Function
Learn how to return text from the middle of a text string.
45 views0 comments
![Excel Find and Select Blanks](https://static.wixstatic.com/media/749de7_7f5b07fad4594203b67c0eada103fead~mv2.png/v1/fill/w_378,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_7f5b07fad4594203b67c0eada103fead~mv2.webp)
Spreadsheet Nation
Nov 1, 20191 min read
Excel Find and Select Blanks
Find and Select blank cells in a data set.
61 views0 comments
![Print Titles](https://static.wixstatic.com/media/749de7_334d97da7c8441f4a436bb4770fa6298~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_334d97da7c8441f4a436bb4770fa6298~mv2.webp)
Spreadsheet Nation
Oct 28, 20191 min read
Print Titles
Print column and row titles on each page when printing out a spreadsheet.
13 views0 comments
![Excel Combo Chart](https://static.wixstatic.com/media/749de7_86fef3ec6b374ec5b013efb4c291b430~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_86fef3ec6b374ec5b013efb4c291b430~mv2.webp)
Spreadsheet Nation
Oct 5, 20191 min read
Excel Combo Chart
Add a secondary axis to graphs with a Combo chart.
28 views0 comments
![Excel Drop-Down Lists](https://static.wixstatic.com/media/749de7_e0571ab1a8ff495ebaa24bc1a8a74b0a~mv2.png/v1/fill/w_140,h_111,fp_0.50_0.50,q_95,enc_auto/749de7_e0571ab1a8ff495ebaa24bc1a8a74b0a~mv2.webp)
Spreadsheet Nation
Sep 27, 20191 min read
Excel Drop-Down Lists
Create a drop-down list in a cell.
22 views0 comments
![Remove Duplicates](https://static.wixstatic.com/media/749de7_dba29d552a7d4df8b440aa9da699697e~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_dba29d552a7d4df8b440aa9da699697e~mv2.webp)
Spreadsheet Nation
Sep 20, 20191 min read
Remove Duplicates
Remove duplicate items in a list.
26 views0 comments
![Time Calculations](https://static.wixstatic.com/media/749de7_e805dd97ab5b4b43bdc8278c8435200f~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_e805dd97ab5b4b43bdc8278c8435200f~mv2.webp)
Spreadsheet Nation
Sep 13, 20192 min read
Time Calculations
Calculate the difference between two times with Excel
33 views0 comments
![Freeze Panes](https://static.wixstatic.com/media/749de7_7755e035c3ca4f2f811a3affdfb9f3a9~mv2_d_3369_1593_s_2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_7755e035c3ca4f2f811a3affdfb9f3a9~mv2_d_3369_1593_s_2.webp)
Spreadsheet Nation
Sep 4, 20192 min read
Freeze Panes
Make a row and/or column stay in place when scrolling in Excel or Google Sheets.
17 views0 comments
![Excel Auto Fill Options](https://static.wixstatic.com/media/749de7_9f0a1b53e562444a9f20c9ecba0d2b81~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/749de7_9f0a1b53e562444a9f20c9ecba0d2b81~mv2.webp)
Spreadsheet Nation
Sep 3, 20193 min read
Excel Auto Fill Options
Make Excel fill out data automatically based on patterns.
32 views0 comments
bottom of page