Disabling Protected View in Excel Sheets for Trusted Documents Only – Office16

Sometimes you keep opening a sheet that you have on your computer and every time it opens it launches in Protected View. If you've tried going to File > Options > Trust Center > Trust Center Settings > Protected View > and disabling everything, you shouldn't. Make sure those all say "Enabled" for security, otherwise … Continue reading Disabling Protected View in Excel Sheets for Trusted Documents Only – Office16

Advertisements

Sort Excel Data By Numbers and Text Properly

instead of: game 10 game 2 game 24 game 3 Use ASAP Utilities Tab "Range" icon Select "Advanced Sorting" from the menu Sort By: "Alphanumeric Content" Then By: "Value" to get: game 2 game 3 game 10 game 24

Combining Columns in Excel

use the following formula to combine data from two columns into one =A2&C2&E2 enter this formula into a new column, copy the column, and "Paste Special" with "Values" only and use this formula to keep a space between items which you are combining =A2&" "&C2&" "&E2

Convert Numbers into Month Names in Excel

To convert cells with month numbers such as 1, 2, 3, 4, etc, use the following formulas: =TEXT(DATE(2000,A1,1),"mmmm") for Full Month Name (January, February, March, April) =TEXT(DATE(2000,A1,1),"mmm") for 3-letter Month Abbreviation (Jan, Feb, Mar, Apr) =TEXT(DATE(2000,A1,1),"mmmmm") for 1st letter of Month (J, F, M, A) Paste the formula in a blank cell to the side … Continue reading Convert Numbers into Month Names in Excel