What Does $A$1 Mean In Excel Or Google Sheets?
What does $A$1 mean in a spreadsheet formula in Excel or Google Sheets? The syntax $A$1 is simply an absolute reference to cell A1. The reason why there are dollar …
Spreadsheets
If there’s one application I have come to appreciate more and more throughout my career it’s the humble spreadsheet. Without this application, I would be lost.
I use this type of software every day and have been using it since 1995 and Microsoft Excel.
However, since working with Google Apps more frequently I’ve found I tend to do a lot more work with Google Sheets at work than Microsoft Excel. I have found the sharing and collaboration feature with Google Sheets a handy and powerful feature.
How To Use Absolute Cell References In Excel And Google Sheets
How do you use absolute cell references in a spreadsheet like Excel or Google Sheets? An absolute cell reference is a reference containing the common column letter and row number …
How To Delete App Script File And Project From Google Sheets
How do delete an attached Google App Script file and project from a Google Sheet? I recently wanted to copy a Google Sheet and as I did I noticed it …
Conditional Formatting With Custom Formula Using Relative References
How can you apply conditional formatting using a custom formula that contains a relative reference to an adjacent row or column in Google Sheets? If you want to highlight a …
How Can Google Sheets Drop Down List Do Multiple Select?
Can a Google Sheets drop-down list in a cell allow you to do multiple select? Google Sheets doesn’t natively support the ability to select more than one item on a …
Sum Each Unique Cell And Show Total Only On The First Or Last Instance Of Each Unique Cell
How do you find the sum of data according to each unique instance of values in a column and then insert the sum calculation for each unique cell at the …
How To Make An Email Address Clickable In Excel
How do you make an email address in an Excel spreadsheet clickable? To make an email address clickable in a spreadsheet check the format of the cell is not set …
Set Conditional Format Based On Another Cell Value In Google Sheets
How can you create a conditional format in Google Sheets based on the value from another cell or column regardless of whether that cell is on the same sheet or …
“We’re sorry, a server error occurred while reading from storage. Error code NOT_FOUND.”
What do you do when you’re running a Google App Script and you encounter the following error in the Execution Log area? Check the libraries you have attached to your …
How To Clean And Format Phone Numbers In Google Sheets
If you’re working with data in Google Sheets you’ll soon come across a time when you will need to clean and format phone number data entries. To clean phone numbers …
Alternatives To VLOOKUP Function When You Want Values To The Left Of VLOOKUP Range
How do you get the value from a column that is to the left of a VLOOKUP range? The VLOOKUP function is a powerful function that enables you to capture …
How To Format Text Like “1st Jan 22” To A Date In Google Sheets
How do you format a cell that contains text like 1st Jan 2022 into a cell that Google Sheets can recognize as a date cell? There are certain types of …
How To Sort By Date In Google Sheets And What To Do When It Doesn’t Work
How do you sort a range containing dates in Google Sheets? Sorting a data set in columns or rows containing date data in Google Sheets can easily be done by …
How To Use The SWITCH Function In Google Sheets?
The SWITCH() function in Google Sheets is handy when dealing with multiple criteria based on a single result. The SWITCH() function takes at least 3 parameters, with the first parameter …
How To Add In Excel: Use + Or A Formula? (Examples)
A spreadsheet helps users to be able to perform calculations without doing this process manually by hand. As you come to use spreadsheets more often you’ll be impressed at the …
How To Separate Characters Into Cells In Excel
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
How Do You Type A “+” (Plus) In Excel?
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …
How To Get Rid Of E+(Number) In Excel
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
Why Does VLOOKUP Return #N/A When Value Exists? (Examples)
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
How To Use Multiple Ranges In QUERY Function: Google Sheets
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
