• Skip to main content
  • Skip to primary sidebar

Nerd Excel

Excel Simplified

  • Excel
  • Google Sheets
  • Word
  • Google Docs

Google Sheets

How to Generate Random Numbers in Google Sheets

Generate Random Numbers in Google Sheets

Looking to populate your Google Sheets spreadsheet with a bunch of randomized data? You can vastly speed up the process by making use of built-in functions. There are two different […]

How to Sort by Multiple Columns in Google Sheets

Sort by Multiple Columns in Google Sheets

To easily analyze large spreadsheets, you can make use of sorting functions that will organize your data. For those using Google’s productivity suite, the built-in sorting function allows users to […]

How to Sort Alphabetically in Google Sheets

Sort Alphabetically in Google Sheets

Once a spreadsheet contains numerous lines of data, it becomes difficult to find what you are looking for. It then becomes important to properly sort the data to ensure it […]

How to Insert Bullet Points in Google Sheets

Insert Bullet Points in Google Sheets

While Google Docs makes it easy to add bullets with a menu option, there is no such option to insert bullet points in Google Sheets. Instead, you will need to […]

How to Color Alternate Rows in Google Sheets

Color Alternate Rows in Google Sheets

A lot of people choose to color alternate rows of a spreadsheet to make it more readable. Previously color alternating rows in Google Sheets was a lengthy process, however Google […]

How to Fix #REF! Error in Google Sheets

Fix #REF! Error in Google Sheets

The #REF! error is one of the most annoying formula parse errors in Google Sheets. The error is usually caused by a missing/invalid reference or circular dependency in your formula. […]

How to Fix #DIV/0! Error in Google Sheets

Fix #DIV/0! Error in Google Sheets

A common error in Google Sheets is #DIV/0!. In this article we will be taking a look at what this error is, what causes the error and how you can […]

How to Freeze Rows and Columns in Google Sheets

Freeze Rows and Columns in Google Sheets

When working with large datasets it becomes difficult to keep track of what each row and column represents as you start scrolling down or rightwards. Luckily you can easily solve […]

How to Edit a View Only Google Sheets Spreadsheet

Edit a View Only Google Sheets Spreadsheet

Have you recently come across a Google Sheets spreadsheet that you cannot edit because it is in view only mode? If this is the case with you, then read on […]

How to Fix Circular Dependency Detected Error in Google Sheets

Fix Circular Dependency Detected Error in Google Sheets

A fairly annoying error in Google Sheets is the circular dependency detected error. When Google Sheets returns this error, it provides no information on why this error is happening. In […]

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Popular Now

  • How to Generate Random Numbers in Google Sheets
  • How to Generate Random Numbers in Excel
  • How to Unprotect Excel Sheet Without Password
  • How to Type With Voice in Google Docs
  • How to Make Google Docs Read to You

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