# Spreadsheetplanet.com how to use exel, tips & tricks excel

### Spreadsheet Planet

**Details: **Convert Military Time to Standard Time in **Excel** (Formulas) A lot of organizations prefer to use the 24-hour ‘military time’. These include the airline industry, public transport, and of course the armed forces. Besides organizations, there are a lot …. Read more.

› Verified *Just Now*

› Url: https://spreadsheetplanet.com/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Start Excel in Safe Mode (3 Easy Ways

**Details: **Opening **Excel** in Safe Mode with a Keyboard Shortcut. You can open **Excel** in Safe mode directly by using its shortcut icon, along with the CTRL key of your keyboard. Here are the steps you need to follow to open **Excel** in Safe mode using this method: Locate the **Excel** shortcut. It could be on your desktop, taskbar, or in your Start menu.

› Verified *2 days ago*

› Url: https://spreadsheetplanet.com/start-excel-safe-mode/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Square a Number in Excel (2 Simple Methods

**Details: **In **Excel**, you can raise one number to the power of another using the exponent operator, also known as a caret symbol (‘^’). So to square the value in cell A2 you need to raise it to the power of 2. For this, you can use the formula: =A2 ^ 2.

› Verified *3 days ago*

› Url: https://spreadsheetplanet.com/square-number-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Create Barcodes in Excel (Easy Step-by-Step

**Details: ****Excel**, in its bid to be as helpful as possible, does some automatic number formatting by default. For example, if you enter 0001 in a cell, it will be converted into 1 (as **Excel** thinks the leading zeroes are useless). Or if you enter a large number, say 123456789876, **Excel** will change it to 1.23457E+11.

› Verified *5 days ago*

› Url: https://spreadsheetplanet.com/barcodes-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Calculate Standard Error in Excel (Step-by-Step

**Details: **10 Microsoft Excel Alternative Tools (Free and Paid) - Beebom

› Verified *1 days ago*

› Url: https://spreadsheetplanet.com/calculate-standard-error-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Flash an Excel Cell (Easy Step-by-Step Method

**Details: ****Excel** lets you define your own custom styles that you can apply to any cell in your worksheet. Cell styles let you apply different types of formatting to a cell in one step. For example, say you want a cell to have a specific background color, a specific font size, type, and color, with specific borders.

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/how-to-flash-excel-cell/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Extract Number from Text in Excel (Beginning, End

**Details: **The above code creates a user-defined function called ExtractNumbers () that you can use in your** worksheet** to extract numbers from mixed text in any cell. To get to your VBA developer window, follow these steps: From the Developer tab, select Visual Basic. Once your VBA window opens, Click Insert- …

› Verified *1 days ago*

› Url: https://spreadsheetplanet.com/extract-number-from-text-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Use e in Excel Euler's Number in Excel

**Details: **How to Use e in **Excel**. The value of e is mostly used in combination with a rate and a time period, often having the value of e raised to the power of some variable(s). Owing to its application in numerous areas **Excel** has the handy EXP function in its stash of statistical tools.

› Verified *2 days ago*

› Url: https://spreadsheetplanet.com/how-to-use-e-in-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### Convert Bytes to MB or GB in Excel (2 Easy Ways

**Details: **So, you can use it to convert Bytes to MB or GB and vice-versa. The syntax for the CONVERT function is: =CONVERT ( number, from_unit, to_unit) Here, number is the numeric value (or cell reference containing the value) that you want to convert. from_unit is the unit in which number is expressed.

› Verified *9 days ago*

› Url: https://spreadsheetplanet.com/convert-bytes-to-mb-gb-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Convert Radians to Degrees in Excel (Easy Formula

**Details: ****Excel** has a number of built-in trigonometric functions that let you easily calculate the cosine, sine, or tangent of angles. The problem is that these functions give results in radians, rather than degrees. That makes sense from mathematical and scientific points of view, but degrees are a more commonplace representation of angles. As such, it

› Verified *3 days ago*

› Url: https://spreadsheetplanet.com/convert-radians-to-degrees-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Multiple If Statements in Excel (Nested Ifs, AND/OR) with

**Details: ****Excel** If Statement. This is the simple or basic If statement which is used to test conditions that can return two results i.e, either TRUE or FALSE. Let’s take a data set which is shown above. Here we use **Excel** If contains data set to check whether the student is Pass or fail based on his or her scores.

› Verified *2 days ago*

› Url: https://spreadsheetplanet.com/multiple-if-statements-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Undo in Excel (2 Easy Ways)

**Details: **How to Undo in **Excel** Using a Keyboard Shortcut. This is the quickest way to undo a previous change. Using the keyboard shortcut CTRL+Z (on a PC) or CMD+Z (on a Mac), you can step back one level to undo the last change that you made to your spreadsheet. Pressing the shortcut again will take you one step further back and so on.

› Verified *1 days ago*

› Url: https://spreadsheetplanet.com/how-to-undo-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Replace Asterisks in Excel (2 Easy Ways

**Details: ****Excel**’s Find and Replace dialog box is a great way to find items on your worksheet and get things done quickly. All you need to do is enter your search string to specify what you want to replace and then specify what you want to replace it with. Now as mentioned before, the asterisk is a wildcard character in **Excel**…

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/replace-asterisks-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Excel If Statement with Multiple Conditions

**Details: ****Excel** If with Sum, Average, Min, and Max functions; Let’s take an example where we want to calculate the performance of any student with Poor, Satisfactory, and Good. If the data set has a predefined structure that will not allow any of the modifications. Then you can add values with this If formula:

› Verified *5 days ago*

› Url: https://spreadsheetplanet.com/excel-if-statement-multiple-conditions-range/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Unsort in Excel (Revert Back to Original Data

**Details: **Below are the steps to unsort the data in **Excel**: Right-click on the left-most column. Click on the Insert column option. This will insert a blank column at the left of your dataset. [Optional] Add a header in cell A1. Add 1 in cell A2 and 2 in cell A3. Select both the cells (A2 and A3), place the cursor over the bottom-right part of the selection.

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/unsort-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Round UP or DOWN to Nearest 5 in Excel (Easy Formula

**Details: **The MROUND function lets you round a value to the nearest multiple of another value. The syntax for the function is as follows: MROUND ( value, factor) Here, value is the number you want to round. factor is the number, the multiple of which the value will be rounded to. So if you want to round a number to the nearest 5, simply specify 5 as the

› Verified *5 days ago*

› Url: https://spreadsheetplanet.com/round-to-nearest-5-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Extract URL from Hyperlinks in Excel (Using VBA

**Details: **If you work with data copied from the web into **Excel**, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where I have the names of some companies and these names are linked to the URL of that company.

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/extract-url-from-hyperlinks-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Apply Short Date Format in Excel

**Details: **Working with dates in **Excel** might not be as simple as working with plain numbers and text, and the reason is that **Excel**’s way of storing and displaying dates is very different. Moreover, **Excel** can display the same date in multiple ways (or formats). The good news though is that it is possible to convert between date formats quite easily.

› Verified *Just Now*

› Url: https://spreadsheetplanet.com/apply-short-date-format-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Make Excel File Read Only

**Details: ****Excel** notifies you that the file you’re opening is read-only and asks you if you want to open it as read-only or not. Possible answers here are: Yes – if you select Yes, the file will be opened in the read-only mode, which means that you will have to save it as new file (with a …

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/make-excel-file-read-only/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Table vs. Excel Range – What’s the Difference

**Details: **An **Excel** Table is a dynamic range of cells that are pre-formatted and organized. A table comes with some additional features such as data aggregation, automatic updates, data styling, etc. You can say that an **Excel** table is basically an **Excel** range, but with some added functionality.

› Verified *7 days ago*

› Url: https://spreadsheetplanet.com/excel-table-vs-excel-range/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using Application.GetSaveAsFilename in VBA in Excel

**Details: **If you are coding in VBScript, **Excel** and you need to extract the filename that a user uses when saving a file, the GetSaveAsFilename() method can be useful for you.. This can be quite helpful when you want the end-user to select a file from their required file location using a GUI like a Save as dialog box.

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/application-getsaveasfilename-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Remove Dashes (-) in Excel

**Details: **Below are the steps to use find and replace to remove dashes in **Excel**: Select the dataset from which you want to remove the dashes. Hold the Control key and then press the H key. This will open the Find and Replace dialog box. In the ‘Find what’ field, type the …

› Verified *3 days ago*

› Url: https://spreadsheetplanet.com/remove-dashes-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Add Text to the Beginning or End of all Cells in Excel

**Details: **An ampersand (&) can be used to easily combine text strings in **Excel**. Let’s see how you use it to add text at the beginning or end or both in **Excel**. Using the ampersand Operator to Add Text to the Beginning of all Cells. The ampersand (&) is an operator that is mainly used to join several text strings into one.

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/add-text-to-beginning-or-end-of-cells-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Autofill Dates in Excel (Autofill Months/Years

**Details: ****Excel** has some amazing features using which you can easily fill a column with a series of dates (be it dates or months or years). In this article, I will show you how to use the autofill option in order to populate a list with dates, months, years, or working days.

› Verified *1 days ago*

› Url: https://spreadsheetplanet.com/autofill-dates-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Select Multiple Rows in Excel (3 Easy Ways

**Details: ****Excel** provides a convenient Name Box to help you quickly select cells using their cell references. The Name Box appears in the form of an input box located at the top left of the **Excel** window, directly below the menu ribbon. In general,

› Verified *7 days ago*

› Url: https://spreadsheetplanet.com/select-multiple-rows-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Add a Total Row in Excel Table (Easy Step-by-Step

**Details: **An **Excel** Table is a dynamic set of rows and columns that are pre-formatted and organized, along with various special Table features, like data aggregation, data styling, automatic updates, etc. The data aggregation comes in the form of a Total Row , which gives you summary calculations for each column, like the sum , average , count , etc.

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/add-total-row-excel-table/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Calculate Hours between two Times in Excel

**Details: **In **Excel** time is represented as a fraction of a 24 hour day. This means that time is internally stored as a decimal number, where 24 hours are represented with a value of 1.0. An hour is simply one-twenty-fourth of a day. Therefore, an hour is represented as 1/24 or 0.0416667.

› Verified *Just Now*

› Url: https://spreadsheetplanet.com/calculate-hours-between-two-times-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Apply Accounting Number Format in Excel

**Details: **What is the Accounting Number Format? **Excel** provides a number of formatting options for numbers, text, dates, and other types of data. To work with data related to money, there are two formatting options available – the Currency format and the Accounting number format.. Both these formats are fairly similar, in that, both add a currency symbol (usually the dollar symbol by default), two

› Verified *Just Now*

› Url: https://spreadsheetplanet.com/apply-accounting-number-format-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Convert Month Name to Number in Excel

**Details: **In **Excel**, it is possible to represent a date in the “mmmm” or “mmm” format. These formats represent the underlying date with the full or partial month name respectively. For example, the date 01/01/2021 is displayed as “ January ” if it is specified in the “ mmmm ” format, …

› Verified *5 days ago*

› Url: https://spreadsheetplanet.com/convert-month-name-to-number-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Switch Axis in Excel (Switch X and Y Axis

**Details: ****Excel** by default sets the first column of the data source on the X-axis, and the second column on the Y-axis. In this case, you can just move Quantity in column B, and Sales in column C. Switching the axis option in a chart gives you more flexibility for adjusting the chart axis. Also, this way you don’t need to change any data in your sheet.

› Verified *1 days ago*

› Url: https://spreadsheetplanet.com/switch-axis-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Unmerge All Cells in Excel

**Details: **In **Excel**, the Find and Replace feature lets you find and select merged cells quickly and easily. Here’s how you can use it to find and unmerge your required cells in **Excel**: Select all the cells by pressing CTRL+A on the keyboard or clicking on the Select All Cells button.

› Verified *3 days ago*

› Url: https://spreadsheetplanet.com/unmerge-cells-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Clear Contents in Excel without Deleting Formulas

**Details: ****Excel** allows you to clear content in the worksheets selectively. So, you can clear the contents in all the cells except the ones that have formulas. This can be useful if you use a template that has some formulas applied in it. You can delete all the cells with values and keep the formulas, so that the next time you copy paste data into it

› Verified *7 days ago*

› Url: https://spreadsheetplanet.com/clear-contents-without-deleting-formulas-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using Conditional Formatting with OR Criteria in Excel

**Details: **This means that **Excel** will decide which cells to format based on the result of a formula. What are Logical Functions in **Excel**? Logical functions like OR, AND and NOT let you carry out more than one comparison, or test multiple conditions. The function returns a logical value based on the set of conditions, which can be either TRUE or FALSE.

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/conditional-formatting-with-or-criteria-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Bold Text using VBA in Excel

**Details: **The ‘Bold’ button in the **Excel** Home tab is of course everyone’s go-to way of making any text bold. A lot of people also like to use the keyboard shortcut CTRL+B. However, you might need to make some text bold based on a certain condition, or only at the end of a calculation.

› Verified *9 days ago*

› Url: https://spreadsheetplanet.com/bold-text-using-vba-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Remove Text after a Specific Character in Excel (3

**Details: ****Excel**’s Find and Replace dialog box is quite versatile as it provides a very efficient way to find items on your worksheet and get things done quickly. All you need to do is enter your search string to specify what you want to replace and then specify what you want to replace it with.

› Verified *3 days ago*

› Url: https://spreadsheetplanet.com/remove-text-after-specific-character-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Move Row to Another Sheet Based On Cell Value in Excel

**Details: **Two Ways to Move Row to Another Sheet Based on Cell Value in **Excel**. There are two ways to move rows to another sheet based on a cell value. The first method is a more manual method, that involves the use of filters to extract the rows that match a given cell value.

› Verified *2 days ago*

› Url: https://spreadsheetplanet.com/move-row-to-another-sheet-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Reverse a Text String in Excel (Using Formula & VBA

**Details: **Even though there aren’t any built-in **Excel** functions for string reversal, there are a number of different ways to do this. You can use either a formula or a script written in VBA. In this tutorial, we will see two ways to reverse a text string using a formula. If you like to use macros, then we also have a VBA script to help you reverse

› Verified *6 days ago*

› Url: https://spreadsheetplanet.com/reverse-text-string-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using Application.EnableEvents in VBA in Excel (Explained

**Details: ****Excel** VBA allows you to create event-specific code, where you can specify what code to run in case the user double-clicks on a cell. In this case, this would be the double-click event. Similarly, you can have a code that is run as soon as a new worksheet is activated in the workbook.

› Verified *5 days ago*

› Url: https://spreadsheetplanet.com/application-enableevents-vba-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Generate Random Numbers in Excel (Without

**Details: **The RANDBETWEEN function is a great function that helps you generate random whole numbers between an upper and lower limit. The syntax for this function is: =RANDBETWEEN ( [lower_limit], [upper_limit]) In the above formula, you can specify the lower and the upper limit. For example, if the limits are 10 and 1000, this formula will generate

› Verified *9 days ago*

› Url: https://spreadsheetplanet.com/generate-random-numbers-without-duplicates-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Auto Format Formulas in Excel (3 Easy Ways

**Details: **Below are the steps to use Go To** Special** to select all cells with Formulas and then format these: Select the dataset in which you want to format the cells with formulas. Hit the F5 key – this will open the Go To dialog box. Click on the** Special** button. In the Go To** Special** dialog box, Click on Formulas. Click OK.

› Verified *7 days ago*

› Url: https://spreadsheetplanet.com/auto-format-formulas-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Convert Date to Day of Week in Excel (3 Easy Ways

**Details: **Method 1: Converting Date to Day of Week in **Excel** using the TEXT Function The TEXT function is a great function to convert dates to different text formats. It takes a date serial number or date and lets you extract parts of the date to fit your required format.

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/convert-date-to-day-of-week-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Unhide All Rows in Excel with VBA

**Details: **Below is the VBA code that will instantly unhide all the rows in the entire** worksheet;** Sub UnhideAllRows () Rows.EntireRow.Hidden = False End Sub. In case you want to unhide** sheets** in a specific range only (let’s say unhide all hidden rows in the first 20 rows only), you can use the below code: Sub UnhideSpecificROws () For i = 1 To 20 Rows

› Verified *2 days ago*

› Url: https://spreadsheetplanet.com/unhide-rows-vba-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Paste in a Filtered Column Skipping the Hidden

**Details: **Press ALT+; (ALT key and semicolon key together). If you’re on a Mac, press Cmd+Shift+Z. This shortcut lets you select only the visible rows, while skipping the hidden cells. Press CTRL+C or right-click->Copy to copy these selected rows. Select the first cell where you want to paste the copied cells.

› Verified *4 days ago*

› Url: https://spreadsheetplanet.com/paste-filtered-column-skipping-hidden-cells/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Top Categories

### Recently Searched

› Copy and paste checkbox excel

› Alteryx writing to multiple excel sheets

› Combine multiple tables excel

› Tips on using excel spreadsheet

› Excel open document recovery pane

› Air duct sanitation fletcher hills excel

› Excel subtotal not working correctly

› Excel training online courses

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel