Excel Basics Archives - Page 175 of 177

How to Show Formula in Cells Instead of Value in Excel (7 Ways)

Feb 8, 2023

In Excel, a lot of things are done using the functions that together make formulas. In this article, we are going to show you some tips on "How to ...

How to Show Formula in Cells Instead of Value in Excel (7 Ways)

How to Copy and Paste Multiple Cells in Excel (8 Quick Methods)

Oct 11, 2022 8

While working in Microsoft Excel, you will need to copy and paste multiple cells to various positions. But sometimes it becomes difficult while ...

How to Copy and Paste Multiple Cells in Excel (8 Quick Methods)

Excel Formula Symbols Cheat Sheet (13 Cool Tips)

Jan 29, 2023 1

In this article, you are going to see some Excel formula symbols cheat sheet. This article will be helpful for learning about the process of ...

Excel Formula Symbols Cheat Sheet (13 Cool Tips)

How to Insert Formula for Entire Column in Excel (6 Quick Ways)

Feb 19, 2023 11

The heart and soul of an Excel spreadsheet are its formulas and typically you apply these formulas in a range of cells located in columns or rows. ...

How to Insert Formula for Entire Column in Excel (6 Quick Ways)

How to Make Excel File Read Only (2 Quick Methods)

Feb 8, 2023

If you want no one can edit or update your Excel file without your permission, you can make your Excel file read-only. No problem if you don't know ...

How to Make Excel File Read Only (2 Quick Methods)

How to Print Excel Spreadsheet with Lines and Change Its Color

Mar 14, 2023 2

Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Look no further since I will ...

How to Print Excel Spreadsheet with Lines and Change Its Color

How to Apply Accounting Number Format in Excel (4 Useful Methods)

May 23, 2023 1

If you are looking for how to apply accounting number format, then you are in the right place. In this article we'll try to discuss how to apply ...

How to Apply Accounting Number Format in Excel (4 Useful Methods)

Creating and Editing Comments in Excel (4 Practical Examples)

Dec 11, 2022

While working in Microsoft Excel Sometimes we feel the need to create and edit comments so that other users can see and reply according to them. I ...

Creating and Editing Comments in Excel (4 Practical Examples)

Viewing Excel Worksheets in Multiple Ways

Feb 26, 2023

In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. ...

Viewing Excel Worksheets in Multiple Ways

How to Hide and Unhide Excel Worksheets from a Workbook

Oct 11, 2022

If you are looking for how to hide and unhide Excel worksheets from a workbook, then you are in the right place. In some situations, while using ...

Excel Table vs. Range: What Is the Difference?

Sep 21, 2022

There is a great deal of confoundment regarding Table and Range in Excel. Especially, the new Excel users often mistake a table for a range and vice ...

Excel Table vs. Range: What Is the Difference?

Excel Table Formatting Tips – Change the Look of the Table

Apr 27, 2023

When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the ...

Excel Table Formatting Tips – Change the Look of the Table

How to Add or Remove Cell Borders in Excel

Feb 7, 2023

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders ...

How to Add or Remove Cell Borders in Excel

Viewing Multiple Workbooks: Synchronous Scrolling in Excel

Sep 13, 2022 2

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and use Excel Synchronous ...

Viewing Multiple Workbooks: Synchronous Scrolling in Excel

What Is the Order of Operations in Excel (An Ultimate Guide)

May 29, 2023 3

Everything in this world run in order. In terms of working with Microsoft Excel, you also need to maintain the order of operations. Understanding the ...