Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.