Categories
Microsoft Excel

Convert Numbers Stored as Text in Excel (2 Ways to Fix All!)

Sometimes when you import or copy and paste numbers into Excel, they get stored as text. Here’s how to convert those numbers to values.Continue readingConvert Numbers Stored as Text in Excel (2 Ways to Fix All!)

Categories
Microsoft Excel

Password Protect an Excel Worksheet to Restrict Viewing

Want to know how to password protect an Excel worksheet to keep other users from viewing it? Read on for a step-by-step tutorial.Continue readingPassword Protect an Excel Worksheet to Restrict Viewing

Categories
Microsoft Excel

Shortcut Key to Paste Values in Excel (Boss Mode!)

The keyboard shortcuts for copy and paste are Ctrl + C and Ctrl + V but what if you only want to paste values? Is there a shortcut for that?Continue readingShortcut Key to Paste Values in Excel (Boss Mode!)

Categories
Microsoft Excel

Removing Protection from an Excel Workbook

Passwords can be used to protect the structure of an Excel workbook or encrypt the entire file. Here’s how you remove workbook protection.Continue readingRemoving Protection from an Excel Workbook

Categories
Microsoft Excel

Protected Worksheets: How to Lock and Unlock Cells in Excel

Excel’s protected worksheet feature that lets you lock down specific cells or the entire worksheet. Read on for everything you need to know.Continue readingProtected Worksheets: How to Lock and Unlock Cells in Excel

Categories
Microsoft Excel

Changing Excel’s Background Color: Formatting and Emphasis

You can change Excel’s background color to format and emphasize specific sections in a worksheet. Here’s everything you need to know!Continue readingChanging Excel’s Background Color: Formatting and Emphasis