How To Guide

Causal's cheat sheet on how to do everything you need inside of Excel & Google Sheets

Excel

How to Wrap Text in Excel

There are a few ways to wrap text in Excel. The easiest way is to highlight the text you want to wrap and then go to the Home tab and…

How to Use XLookup in Excel

The XLookup function in Excel is used to lookup values in a table or range of cells. The function takes two arguments: the value to…

How to Use VLOOKUP in Excel

VLOOKUP is a function in Excel that allows you to look up data in a table. You can use it to find a value in a table, or to find a…

How to Use Solver in Excel

The solver is a powerful tool that can be used to solve a variety of optimization problems. In order to use the solver, you first need…

How to Use a Pivot Table in Excel

Pivot tables are a great way to summarize data in Excel. You can use them to quickly see how different data points interact with each…

How to Use Microsoft Excel

Microsoft Excel is a software application that allows users to create and edit spreadsheets. Spreadsheets are grids of cells that can…

How to Use the IF Function in Excel

The IF function in Excel is used to test a condition and return a value based on the result. The function has the following…

How to Use Goal Seek in Excel

Goal seek is a powerful tool in Excel that can be used to solve for a desired result. To use goal seek, you first need to enter the…

How to Use Excel Formulas

There are a few basic Excel formulas that you should know how to use in order to make the most of the program. The SUM function, for…

How to Use Excel

Excel is a software application that is used to produce, organize, and analyze data. It is a widely used program in business,…

How to Use the CountIf Function in Excel

The Excel COUNTIF function counts the number of cells in a range that meet a given criteria. The syntax for the COUNTIF function…

How to Use Conditional Formatting in Excel

There are a few ways to use conditional formatting in Excel. The first way is to highlight a cell or a range of cells that you want to…

How to Use Autofill in Excel

There are a few ways to use autofill in Excel. One way is to highlight the cells you want to fill, and then go to the menu bar and…

How to Unprotect an Excel Workbook

There are a few ways to unprotect an Excel workbook. One way is to use the password protection feature in Excel. To do this, open the…

How to Unprotect Excel

There are a few ways to unprotect an Excel sheet, depending on the level of security you need. If you only need to unprotect the sheet…

How to Unprotect a Sheet in Excel

There are a few ways to unprotect a sheet in Excel. The easiest way is to right-click on the sheet tab and select "Unprotect Sheet". If…

How to Unmerge Cells in Excel

There are a few ways to unmerge cells in Excel. One way is to select the cells you want to unmerge and then go to the Format menu and…

How to Unlock an Excel Worksheet

There are a few ways to unlock an Excel spreadsheet, but the most common way is to use a password. If you know the password, you can…

How to Unlock Cells in Excel

There are a few ways to unlock cells in Excel. One way is to select the cells you want to unlock and then go to the Format menu. Select…

How to Unlock an Excel Spreadsheet

There are a few ways to unlock an Excel spreadsheet, but the easiest is to use a password. If you know the password, you can simply…

How to Unhide Sheets in Excel

There are a few ways to unhide sheets in Excel. The easiest way is to right-click on the tab at the bottom of the Excel window and…

How to Unhide Rows in Excel

There are a few ways to unhide rows in Excel. The easiest way is to click on the "Unhide" button on the "Home" tab. This will open a…

How to Unhide Columns in Excel

There are a few ways to unhide columns in Excel. One way is to select the column letter you want to unhide and then go to the Home tab…

How to Unhide Cells in Excel

There are a few ways to unhide cells in Excel. The easiest way is to select the cells you want to unhide and then go to the Home tab…

How to Unhide All Rows in Excel

There are a few ways to unhide all rows in Excel. One way is to select all of the rows in the spreadsheet by clicking on the row number…

How to Unhide All Columns in Excel

There are a few ways to unhide all columns in Excel. The easiest way is to use the shortcut key: Ctrl+Shift+9. Another way is to go to…

How to Undo in Excel

There are a few ways to undo in Excel. One way is to use the keyboard shortcut Ctrl + Z. This shortcut will undo the last thing that…

How to Transpose in Excel

There are a few ways to transpose data in Excel. One way is to use the transpose function in Excel. To do this, select the cells that…

How to Transpose Data in Excel

There are a few ways to transpose data in Excel. One way is to use the Transpose function in Excel. To do this, select the cells that…

How to Total a Column in Excel

There are a few ways to total a column in Excel. One way is to use the SUM function. The SUM function can be used to total a column of…

How to Switch Columns in Excel

There are a few ways to switch columns in Excel. One way is to use the mouse. With the mouse, you can click and drag the column letter…

How to Sum in Excel

To sum in Excel, you can use the SUM function. The SUM function takes a range of cells as an input and returns the sum of the values in…

How to Sum a Column in Excel

There are a few ways to sum a column in Excel. One way is to use the SUM function. The SUM function takes a range of cells as an input…

How to Subtract Time in Excel

To subtract time in Excel, you can use the subtraction operator (-) to subtract two times or use the TIME() function to subtract the…

How to Subtract in Excel

To subtract in Excel, you can use the subtraction operator "-". For example, if you want to subtract the value in cell A1 from the…

How to Subtract Dates in Excel

To subtract two dates in Excel, you can use the "MIN" function. The "MIN" function will return the minimum value between two dates. To…

How to Strikethrough in Excel

In order to strikethrough text in Excel, you will need to highlight the text that you would like to strikethrough and then select the…

How to Split One Cell into Two in Excel

There are a few ways to split one cell into two in Excel. One way is to use the split function. To do this, type…

How to Split First and Last Name in Excel

There are a few ways to split a first and last name in Excel. One way is to use the TEXTJOIN function. The TEXTJOIN function will allow…

How to Split Cells in Excel

There are a few ways to split cells in Excel. One way is to use the split function. To do this, type "=SPLIT(cell reference,split…

How to Split a Cell in Excel

There are a few ways to split a cell in Excel. One way is to use the text to columns function. To do this, highlight the cells you want…

How to Spell Check in Excel

To spell check in Excel, you can use the spell checker built into the software. This spell checker will check your text for errors and…

How to Sort in Excel

There are a few ways to sort in Excel. The most basic way is to click on the column header you want to sort and then click on the…

How to Sort Data in Excel

There are a few ways to sort data in Excel. The most basic way is to click on the column header you want to sort and then drag it up or…

How to Sort Columns in Excel

There are a few ways to sort columns in Excel. The easiest way is to click on the column header you want to sort and then use the Sort…

How to Sort by Date in Excel

To sort by date in Excel, you can use the Sort command on the Home tab. In the Sort & Filter group, click the Sort button, and then…

How to Sort Alphabetically in Excel

There are a few ways to sort alphabetically in Excel. The first way is to use the Sort function. To do this, select the cells that you…

How to Show Formulas in Excel

There are a few ways that you can show formulas in Excel. The easiest way is to press the "F2" key on your keyboard. This will bring up…

How to Share an Excel File

There are a few different ways that you can share an Excel file. One way is to send the file as an email attachment. Another way is to…

How to Shade Every Other Row in Excel

There are a few ways to shade every other row in Excel, but the easiest way is to use the fill handle. To do this, select the cells you…

How to Set Print Area in Excel

There are a few ways to set a print area in Excel. One way is to select the cells you want to print and then go to the File menu and…

How to Separate Text in Excel

There are a few ways to separate text in Excel. One way is to use the CLEAN function. The CLEAN function removes all non-printable…

How to Separate Names in Excel

There are a few ways to separate names in Excel. One way is to use the comma as a separator. Another way is to use the space as a…

How to Separate First and Last Name in Excel

There are a few ways to separate first and last name in Excel. One way is to use the text function. To do this, type "=text(A1,"")"…

How to Select Non Adjacent Cells in Excel

There are a few ways to select non-adjacent cells in Excel. One way is to use the mouse to draw a selection rectangle around the cells…

How to Select Multiple Cells in Excel

To select multiple cells in Excel, hold down the Ctrl key on your keyboard and click on each cell you want to select. Once all of the…

How to Search in Excel

To search for a value in Excel, you can use the "Find and Replace" feature. First, select the cell or range of cells that you want to…

How to Search for Duplicates in Excel

There are a few ways to search for duplicates in Excel. The easiest way is to use the built-in "Find and Replace" feature. First,…

How to Save Excel as a PDF

There are a few ways to save Excel as a PDF. The easiest way is to use the "Save as PDF" function in Excel. To do this, open Excel and…

How to Round Up in Excel

There are a few ways to round numbers up in Excel. The first way is to use the ROUND function. The ROUND function takes a number as an…

How to Round Numbers in Excel

There are a few ways to round numbers in Excel. The simplest way is to use the built-in Round function. The Round function takes two…

How to Round Numbers in Excel

There are a few ways to round numbers in Excel. The most common way is to use the round function. The round function takes two…

How to Rotate Text in Excel

In Excel, text can be rotated by using the rotate text function. The rotate text function can be used to rotate text by a specified…

How to Return a Value in Excel

To return a value in Excel, you can use the = operator to assign a value to a cell. For example, if you want to return the value…

How to Remove Table Formatting in Excel

There are a few ways to remove table formatting in Excel. One way is to select all of the cells in the table and then go to the Format…

How to Remove Spaces in Excel

There are a few ways to remove spaces in Excel. One way is to select the cells with the spaces and then press the delete key. Another…

How to Remove a Password from Excel

There are a few different ways to remove a password from Excel. One way is to open Excel and go to the "File" tab. Then, select "Open"…

How to Remove Page Breaks in Excel

There are a few ways to remove page breaks in Excel. One way is to use the "Find and Replace" function. To do this, highlight the text…

How to Remove a Hyperlink in Excel

There are a few ways to remove a hyperlink in Excel. The easiest way is to select the hyperlink and press the delete key on your…

How to Remove Gridlines in Excel

Gridlines in Excel can be removed by formatting the cells to have no border. To do this, select the cells you want to format and go to…

How to Remove Empty Rows in Excel

There are a few ways to remove empty rows in Excel. One way is to highlight the empty rows, go to the "Data" tab, and select "Remove…

How to Remove Duplicates in Excel

There are a few ways to remove duplicates in Excel. One way is to use the Remove Duplicates function under the Data tab. To do this,…

How to Remove a Drop down List in Excel

There are a few ways to remove a drop down list in Excel. One way is to select the drop down list and then press the Delete key on your…

How to Remove Blank Rows in Excel

There are a few ways to remove blank rows in Excel. The easiest way is to highlight the rows you want to delete, go to the Home tab,…

How to Recover an Unsaved Excel File

There are a few ways to recover an unsaved Excel file, but the most common is to use the "Recover Unsaved Files" feature. This feature…

How to Recover an Excel File

There are a few ways to recover an Excel file. One way is to try to open the file and see if Excel will automatically repair it. If the…

How to Recover a Deleted Excel File

There are a few ways to try and recover a deleted Excel file. One way is to check the recycle bin to see if the file was accidentally…

How to Randomize a List in Excel

There are a few ways to randomize a list in Excel. One way is to use the RANDBETWEEN function. This function will generate a random…

How to Protect Cells in Excel

There are a few ways to protect cells in Excel:</p>1) You can password protect a sheet by going to "Review" and then "Protect…

How to Print Labels from Excel

There are a few ways to print labels from Excel. One way is to create a mail merge document using Word. To do this, you would first…

How to Print Gridlines in Excel

Gridlines are the lines that appear on the Excel spreadsheet between the columns and rows. They are helpful in aligning data and making…

How to Print Excel with Lines

There are a few ways to print Excel with lines. One way is to use the Page Layout view in Excel. To do this, go to the View tab and…

How to Print Excel on One Page

There are a few ways to print Excel on one page. One way is to select the print range and then select print preview. Under the print…

How to Print Address Labels from Excel

There are a few ways to print labels from Excel. One way is to create a label template in Excel. To do this, open a new Excel document…

How to Pin a Row in Excel

There are a few ways to pin a row in Excel. One way is to right-click on the row number and select "Pin Row." Another way is to select…

How to Password Protect Excel

There are a few ways to password protect an Excel document. One way is to go to the "Review" tab and select "Protect Sheet." From…

How to Password Protect an Excel File

There are a few different ways to password protect an Excel file. One way is to go to the "File" menu and select "Save As." Under the…

How to Number Rows in Excel

There are a few ways to number rows in Excel. One way is to use the built-in row numbers that Excel provides. To do this, select the…

How to Name a Table in Excel

There are a few things you need to consider when naming a table in Excel:</p>-The name should be short and concise-The name should…

How to Multiply in Excel

To multiply in Excel, you can use the * symbol, or the Excel function "MULTIPLY". To use the * symbol, type the numbers you want to…

Multiply Columns in Excel

Multiplying columns in Excel is a very simple process. First, select the cells that you would like to multiply. Next, use the "*"…

How to Multiply Cells in Excel

There are a few ways to multiply cells in Excel. One way is to use the multiplication symbol (*) between the cells that you want to…

How to Move Rows in Excel

There are a few ways to move rows in Excel. One way is to use the arrow keys on your keyboard. Another way is to select the row you…

How to Move Columns in Excel

There are a few ways that you can move columns in Excel. One way is to use the mouse. First, click on the column heading that you want…

How to Move Cells in Excel

There are a few ways to move cells in Excel. The easiest way is to use the mouse. Simply click and drag the cell to the desired…

How to Move a Row in Excel

There are a few ways to move a row in Excel. One way is to select the row and then use the arrow keys to move it up or down. Another…

How to Move a Column in Excel

There are a few ways to move a column in Excel. The easiest way is to select the column by clicking on the letter at the top of the…

How to Merge Two Excel Spreadsheets

There are a few ways to merge two Excel spreadsheets. The easiest way is to open both spreadsheets and copy and paste the data from one…

How to Merge Two Columns in Excel

There are a few ways to merge two columns in Excel. One way is to use the concatenate function. To do this, highlight the cells you…

How to Merge Columns in Excel

There are a few ways to merge columns in Excel. One way is to use the concatenate function. To do this, type =concatenate( in the first…

Google Sheets

How to Add Cells in Google Sheets

There are a few ways to add cells in Google Sheets. The first way is to select the cell where you want to insert the new cell, and then…

How to Add Columns in Google Sheets

There are a few ways to add columns in Google Sheets. One way is to click on the "Insert" tab and then select "Column." Another way is…

How to Add Numbers in Google Sheets

Adding numbers in Google Sheets is a very simple process. You can either type the numbers into the cells yourself, or you can use the…

How to Add a Column in Google Sheets

Adding a column in Google Sheets is a very simple process. First, open the spreadsheet you would like to add the column to. Next, click…

How to Add a Drop down List in Google Sheets

Adding a drop down list in Google Sheets is a great way to keep track of specific information or to limit the options that are…

How to Add a Drop down List in Google Sheets

Adding a drop down list in Google Sheets is a great way to keep track of data and to make selections easier. You can add a drop down…

How to Add a Trendline in Google Sheets

To add a trendline in Google Sheets, you first need to select the data you want to trend. Once the data is selected, click on the…

How to Add in Google Sheets

There are a few ways to add data in Google Sheets. The first way is to add data manually. To do this, select the cell where you want to…

How to Add on Google Sheets

Adding on Google Sheets is a very simple process. First, open up a Google Sheet. Then, in the top left hand corner, click on the…

How to Alphabetize in Google Sheets

There are a few different ways to alphabetize in Google Sheets. The easiest way is to highlight the cells you want to alphabetize, and…

How to Combine Cells in Google Sheets

There are a few ways to combine cells in Google Sheets. The easiest way is to use the "CONCATENATE" function. This function will…

How to Convert Excel to Google Sheets

There are a few ways to convert Excel to Google Sheets. The first way is to use the importXLS function. The importXLS function takes an…

How to Create a Drop down List in Google Sheets

There are a few ways to create a drop down list in Google Sheets. The easiest way is to use a pre-made list. </p>1. Open a new…

How to Create a Drop-Down List in Google Sheets

There are a few ways to create a drop-down list in Google Sheets. One way is to use the Data Validation tool. To do this, select the…

How to Create a Graph in Google Sheets

There are a few ways to create graphs in Google Sheets. The first way is to use the bar graph tool. To use the bar graph tool, first…

How to Create a Pivot Table in Google Sheets

A pivot table is a data summarization tool that allows you to quickly and easily create a summary of large data sets. It does this by…

How to Filter in Google Sheets

There are a few ways to filter data in Google Sheets. One way is to use the "Filter" function under the "Data" tab. Another way is to…

How to Find Duplicates in Google Sheets

There are a few ways to find duplicates in Google Sheets. The first way is to use the built-in function called "DUPLEXES". To use this…

How to Freeze Cells in Google Sheets

There are a few different ways to freeze cells in Google Sheets. One way is to select the cells you want to freeze and then go to the…

How to Freeze Columns in Google Sheets

There are a few ways to freeze columns in Google Sheets. The easiest way is to select the column you want to freeze and then click on…

How to Freeze Rows in Google Sheets

There are a few different ways to freeze rows in Google Sheets. One way is to select the row you want to freeze and then click on the…

How to Freeze a Column in Google Sheets

There are a few ways to freeze a column in Google Sheets. The first way is to select the column you want to freeze and then go to the…

How to Freeze a Row in Google Sheets

There are a few ways to freeze a row in Google Sheets. One way is to select the row you want to freeze and then go to the View menu and…

How to Freeze a Row in Google Sheets

There are a few different ways to freeze a row in Google Sheets. One way is to select the row you want to freeze and then go to the…

How to Hide Columns in Google Sheets

There are a few different ways that you can hide columns in Google Sheets. One way is to simply select the column that you want to hide…

How to Hide Rows in Google Sheets

There are a few ways to hide rows in Google Sheets. One way is to use the hide function. To hide a row, select the row you want to hide…

How to Highlight Duplicates in Google Sheets

There are a few ways to highlight duplicates in Google Sheets. One way is to use the built-in "Find and Replace" function. Another way…

How to Indent in Google Sheets

There are a few ways to indent in Google Sheets. The easiest way is to use the arrow keys on your keyboard. To indent one tab, press…

How to Insert Multiple Rows in Google Sheets

There are a few ways to insert multiple rows in Google Sheets. The easiest way is to use the copy and paste function. First, select the…

How to Lock Cells in Google Sheets

There are a few ways to lock cells in Google Sheets. One way is to select the cells you want to lock, then go to the "Format" menu and…

How to Lock a Column in Google Sheets

There are a few ways to lock a column in Google Sheets. The first way is to select the column you want to lock and then go to the…

How to Lock a Row in Google Sheets

There are a few ways to lock a row in Google Sheets. One way is to select the row you want to lock and then go to the "Review" tab and…

How to Make Graphs in Google Sheets

There are a few ways to make graphs in Google Sheets. The first way is to use the bar chart tool. To do this, select the data you want…

How to Make a Bar Graph in Google Sheets

To make a bar graph in Google Sheets, you first need to create a spreadsheet with the data you want to graph. Once your data is in the…

How to Make a Calendar in Google Sheets

There are a few different ways that you can make a calendar in Google Sheets. The first way is to use the built-in calendar function.…

How to Make a Chart in Google Sheets

There are a few ways that you can make a chart in Google Sheets. The first way is to select the data that you want to include in your…

How to Make a Drop Down List in Google Sheets

To make a drop-down list in Google Sheets, you first need to create a list of items that you want to appear in the drop-down menu.…

How to Make a Drop Down List in Google Sheets

A drop-down list is a list of options that appear as a menu in a cell in a Google Sheets spreadsheet. When you enter a value in the…

How to Make a Graph in Google Sheets

There are a few ways to make graphs in Google Sheets. The first way is to use the built-in graph function. To do this, select the cells…

How to Make a Graph in Google Sheets

There are a few ways to make graphs in Google Sheets. The first way is to use the bar chart tool. To use the bar chart tool, select the…

How to Make a Graph on Google Sheets

To make a graph on Google Sheets, you first need to create a new spreadsheet and enter the data you want to graph into the spreadsheet.…

How to Make a Line Graph in Google Sheets

There are a few different ways to make line graphs in Google Sheets. The easiest way is to use the built-in line graph…

How to Make a Schedule in Google Sheets

There are a few different ways that you can make a schedule in Google Sheets. One way is to use the built-in schedule function. To do…

How to Make a Table in Google Sheets

There are a few different ways that you can make a table in Google Sheets. One way is to use the "Table" function under the "Insert"…

How to Merge Cells in Google Sheets

There are a few ways to merge cells in Google Sheets. The easiest way is to select the cells you want to merge and then go to the menu…

How to Multiply in Google Sheets

Multiplying in Google Sheets is a simple process. First, enter the numbers you would like to multiply into two adjacent cells in a…

How to Remove Duplicates in Google Sheets

There are a few ways to remove duplicates in Google Sheets. You can use the built-in function called "Remove Duplicates," which will…

How to Save Google Sheets

There are a few ways to save a Google Sheets document. One way is to click on the "File" menu and then select "Download as." From…

How to Save in Google Sheets

There are a few ways to save in Google Sheets. The first way is to save as a PDF. To do this, open the file you would like to save,…

How to Search in Google Sheets

There are a few ways to search for data in Google Sheets. The first way is to use the "Find and Replace" function. To use this…

How to Search on Google Sheets

Google Sheets is a great way to store and organize data. You can search for specific data within a sheet by using the "find and…

How to Sort in Google Sheets

There are a few ways to sort data in Google Sheets. The first way is to click on the "Sort" button in the toolbar. This will open a…

How to Split Cells in Google Sheets

There are a few different ways to split cells in Google Sheets. One way is to use the split function. To do this, type "=SPLIT(A1,B1)"…

How to Split a Cell in Google Sheets

There are a few ways to split a cell in Google Sheets. One way is to use the split function. To do this, type "=split(A1,B1)" into a…

How to Subtract in Google Sheets

To subtract in Google Sheets, you can use the subtraction operator "-". For example, if you want to subtract the numbers 1 and 2, you…

How to Sum a Column in Google Sheets

There are a few ways to sum a column in Google Sheets. One way is to use the SUM function. To use the SUM function, select the cells…

How to Total a Column in Google Sheets

To total a column in Google Sheets, you can use the SUM function. First, select the cells that you want to total. Then, type =SUM( into…

How to Unhide Rows in Google Sheets

To unhide rows in Google Sheets, first select the rows that you want to unhide. Then, click on the "View" menu and select "Unhide…

How to Use Google Sheets

Google Sheets is a versatile online application that can be used to create and edit spreadsheets. It can be used to track and manage…

How to Wrap Text in Google Sheets

There are a few different ways that you can wrap text in Google Sheets. One way is to use the text wrapping feature in the toolbar. To…

Get started today with Causal

Sign up and get started for free, or book a demo to learn how Causal can transform your finance function.