Skip to content
Spreadsheet Planet Logo
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Menu
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Search
Close

Excel Tips Articles

Cells with Orange dashed border

How to Add Cell Borders in Excel (3 Easy Ways)

Click here to Read More »
Formula result is visible in earlier filtered rows only

How to Paste in a Filtered Column Skipping the Hidden Cells

Click here to Read More »
Unique random numbers without duplicates

How to Generate Random Numbers in Excel (Without Duplicates)

Click here to Read More »
Fit sheet on one page

How to Fit to Page in Excel (Print on One Sheet)

Click here to Read More »
Combine Names using Flash Fill with capitalized first letter

How to Merge First and Last Name in Excel (2 Easy Ways)

Click here to Read More »
Names that have been split from one column to two columns

How to Split One Column into Multiple Columns in Excel

Click here to Read More »
Set row height or column width

How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)

Click here to Read More »
Add days to date using the DATE function

How to Add Days to a Date in Excel

Click here to Read More »
Phone Number format dataset

How to Format Phone Numbers in Excel

Click here to Read More »
Multiple column dataset that needs to be sorted by date

How to Sort by Date in Excel (Single Column & Multiple Columns)

Click here to Read More »
Dataset from which filtered rows have been deleted

How to Delete Filtered Rows in Excel (with and without VBA)

Click here to Read More »
Shift key to group the sheets

How to Group and Ungroup Worksheets in Excel

Click here to Read More »
« Previous Page1 … Page3 Page4 Page5 Next »

2021 © Spreadsheet Planet
Privacy Policy | Sitemap

DMCA.com Protection Status