Tag: Excel

Protect an Excel Workbook

Protect an Excel Workbook




Protect a Worksheet’s Data: If you will be distributing a workbook to other people, you can enable Excel’s options for safeguarding worksheet data by activating the sheet’s protection feature. You can also configure the worksheet to require a password to unprotect it.

There are two main methods you can use to safeguard worksheet data: You can unlock only those cells that users are allowed to edit, and you can configure a range to require a password before it can be edited.

Protect a Workbook’s Structure and Windows: You can prevent unwanted changes to a workbook by activating protection for the workbook’s windows and structure. You can also configure the workbook to require a password to unprotect it.

You should protect a workbook’s structure when you do not want others to perform actions such as adding or deleting worksheets; you should protect a workbook’s windows when you do not want others to perform actions such as splitting a window or freezing panes.



Add Comments to an excel Workbook

Add Comments in an Excel Workbook




If you have received a workbook from another person, you can provide feedback to that person by adding a comment to a cell in the workbook. A comment is often the best way to give feedback because it does not change anything on the worksheet itself. Comments are attached to a particular cell, and Excel displays an indicator on any cell that has a comment. When you hover your mouse pointer over such a cell, Excel displays the comment in a balloon.



Convert Ranges to a Table in Excel

Convert Ranges to a Table in Excel




You can apply Excel’s powerful table tools to any range by first converting that range to a table. In Excel, a table is a collection of related information with an organizational structure that makes it easy to add, edit, and sort data. A table is a type of database where the data is organized into rows and columns: Each column represents a database field, and each row represents a database record.



Move or Copy a Formula in Excel

How to Move or Copy a Formula in Excel




You can restructure or reorganize a worksheet by moving an existing formula to a different part of the worksheet. When you move a formula, Excel preserves the formula’s range references.

Excel also enables you to make a copy of a formula, which is a useful technique if you require a duplicate of the formula elsewhere or if you require a formula that is similar to an existing formula. When you copy a formula, Excel adjusts the range references to the new location.


Knowing the Excel Window

Knowing the Microsoft Excel Window



The Excel Window, Now, we are going to learn the excel window parts. To get up to speed quickly with excel, it helps to understand the various elements of the excel window. These include standard window elements such as, the title bar and status bar, as well as office-specific elements such as the ribbon and the file tab.



Using the Microsoft Excel Ribbon

Knowing the Microsoft Excel Ribbon



You use Excel’s Ribbon element to access all of the program’s features and commands. The Ribbon is the horizontal strip that runs across the top of the Excel window, just below the title bar. The Ribbon is organized into various tabs, such as Home, Layout, and Insert, and each tab contains related controls, which usually include buttons, lists, and check boxes.



Formatting Fonts in Microsoft Excel

Formatting Fonts in Microsoft Excel



Change the Font and Font Size: When you work in an Excel worksheet, you can add visual appeal to a cell or range by changing the font and font size. In this section, the term font is synonymous with typeface, and both refer to the overall look of each character. By default, Excel offers nearly 200 different fonts in a wide variety of styles. Also, the font size is measured in points, where there are roughly 72 points in an inch. In some cases, formatting a range with a larger font size can make the range text easier to read. Apply Font Effects: You can improve the look and impact of text in an Excel worksheet by applying font effects to a range. Excel’s font effects include common formatting such as bold, italic, and underline, which are available on the Ribbon for easy application. Excel also offers a dialog box tab that includes many more font effects, including special effects such as strikethrough, superscripts, and subscripts. In most cases, you should not need to apply more than one or two font effects at a time. If you use too many effects, it can make the text difficult to read. Change the Font Color: When you build an Excel worksheet, you can add visual interest to the sheet text by changing the font color. By default, each Excel workbook comes with a theme applied, and you can change the font color by applying one of the colors from the workbook’s theme. You learn more about workbook themes in other chapter. You can also select a color from Excel’s palette of standard colors, or from a custom color that you create yourself.


Add a Function to a Formula in Excel

Add a Function to a Formula in Excel




To get the benefit of an Excel function, you need to use it within a formula. You can use a function as the only operand in the formula, or you can include the function as part of a larger formula.

In “Understanding Excel Functions,” you learned that Excel has many functions and that most functions take one or more arguments, but it is often difficult to remember a function’s arguments and the order in which they appear. To make it easy to choose the function you need and to add the appropriate arguments, Excel offers the Insert Function feature.



Arrange Windows in Excel

How to Arrange Windows in Excel




You can view two or more workbooks at once by arranging the workbook windows within the main Excel window. This enables you to easily compare the contents of the workbooks. Arranging workbook windows also enables you to more easily copy or move data among workbooks. Excel offers four view modes for arranging workbook windows: Tiled, Horizontal, Vertical, and Cascade.