• Skip to main content
  • Skip to primary sidebar

Nerd Excel

Excel Simplified

  • Excel
  • Google Sheets
  • Word
  • Google Docs

Excel

How to Generate Random Numbers in Excel

Generate Random Numbers in Excel

Instead of manually entering in numbers, you can generate random numbers in Excel to automate the process. Excel has two built-in functions, RAND and RANDBETWEEN, which populate cells with randomly […]

How to Unprotect Excel Sheet Without Password

Unprotect Excel Sheet Without Password

Excel sheets and workbooks are usually protected to prevent unwanted changes to the document. The sheet protection feature allows people to view the sheet, but not make changes to it […]

How to Sort Multiple Columns Alphabetically in Excel

Sort Multiple Columns Alphabetically in Excel

Reading thousands of lines in an Excel spreadsheet can be an annoying process, especially when the data is unorganized. Luckily, it is very easy to sort multiple columns alphabetically in […]

How to Sort Alphabetically in Excel

Sort Alphabetically in Excel

Data in an Excel spreadsheet is usually unorganized, unsorted, and hard to read. There are many techniques to make the data easier to read, such as using filters and sorting […]

How to Add Bullet Points in Excel

Insert Bullet Points in Excel

Many users are unaware that it is possible to add bullet points in Excel. While Excel does not provide a built-in functionality to do this, there are four workarounds that […]

How to Color Alternate Rows in Excel

Color Alternate Rows in Excel

To make your data easier to read, you may want to color alternate rows in Excel. Excel provides built in functionality to do this and even alternatively colors newly added […]

How to Freeze Rows in Excel

Freeze Rows in Excel

In Excel, quite often you will want to compare data in completely different areas of your worksheet. Instead of scrolling back and forth between these two areas, you can simply […]

How to Disable Read Only in Excel

Disable Read Only in Excel

In order to protect the data contained within Excel documents, a lot of people make the document read only. When trying to edit a read only Excel worksheet you will […]

How to Delete Blank Rows in Excel

Delete Blank Rows in Excel

Some people prefer having a dataset with blank spaces, but others absolutely detest it. Instead of manually finding and deleting each blank row, you can have Excel do the hard […]

Primary Sidebar

Popular Now

  • How to Calculate Age in Google Sheets
  • How to Sort by Date in Google Sheets
  • How to Generate Random Numbers in Google Sheets
  • How to Generate Random Numbers in Excel
  • How to Unprotect Excel Sheet Without Password

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Nerdexcel.com · All Rights Reserved