Tag: Excel Formatting

Insert a Row & a Column in Microsoft Excel Worksheets

Excel Online Tutorial – Insert a Row & a Column in a Worksheet

You can insert a row or column into your existing worksheet data to accommodate more information. This is particularly useful if the information you need to add fits naturally within the existing data, rather than at the end.

When you insert a row, Excel shifts the existing rows down, so you must first determine the row above where you want your new row to appear. Similarly, when you insert a column, Excel shifts the existing columns to the right, so you must first determine the column to the left of where you want your new column to appear.

Create or Move Excel Worksheets

Create and Move Excel Worksheets

Create a New Worksheet: Excel supports multiple worksheets in a single workbook, so you can add as many worksheets as you need for your project or model. Each new Excel workbook comes with three worksheets, but it is not uncommon to require four or more worksheets in a workbook.

In most cases, you will add a blank worksheet, but Excel also comes with several predefined worksheet templates that you can use. Note that there is no practical limit to the number of worksheets you can add to a workbook.

Move a Worksheet: You can organize an Excel workbook and make it easier to navigate by moving your worksheets to different positions within the workbook. Although you will most often move a worksheet to a different position within the same workbook, it is also possible to move a worksheet to another workbook.

Change Fonts Schemes in Microsoft Excel

Font Schemes in Microsoft Excel

You can add visual appeal to your workbook by selecting a different font scheme. Each font scheme has two defined fonts: a heading font for the titles and headings, and a body font for the regular worksheet text.

Excel offers more than 20 font schemes. To get the most out of Excel’s font schemes, particularly the heading fonts, you must apply styles to your ranges.

Change View of the Excel Window

Change View of the Excel Window

 

 

You can adjust the Excel window to suit what you are currently working on, by changing the view to match your current task. Excel offers three different views. Page Layout, which displays worksheets as they would appear if you printed them out. Normal, which is useful for building and editing worksheets. And Full Screen view, that is useful when you want to see the maximum amount of a worksheet on the screen.

Customizing the Excel Chart Elements Outline

Customizing the Excel Chart Elements Outline

 

 

You can make a chart element stand out by customizing the element’s outline, which refers to the border that appears around the element, as well as to single-line elements, such as gridlines and axes. You can customize the outline’s color, its weight, that is, its thickness, and whether the line is solid or consists of a series of dots or dashes.

Modify Excel Worksheet Colors

Modify the Excel Workbook Colors

 

 







You can give your workbook a new look by selecting a different color scheme. Each color scheme affects the workbook’s text colors, background colors, border colors, and more. Excel offers more than 20 color schemes.

 

 

Select a different Chart Type in Excel

Change the Type of a Chart in Excel

 

 

 

If you feel that the current chart type is not showing your data in the best way, you can change the chart type with just a few mouse clicks. For example, you might want to change a bar chart to a pie chart or a line chart to a stock chart.

You can also save yourself some work by configuring Excel with a new default chart type, and by saving the current chart type and chart formatting as a template that you can reuse later on.

 

 

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.
 

 

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.

 

 

Knowing the Excel Smart Tags

Knowing the Excel Smart Tags

 

 

 

 
You can make your Excel work faster and easier by taking advantage of smart tags. A smart tag is a special icon that appears when you perform certain Excel tasks, such as pasting data and using the AutoFill feature. Clicking the smart tag displays a list of options that enable you to control or modify the task you just performed.

Some smart tags appear automatically in response to certain conditions. For example, if Excel detects an inconsistent formula, it displays a smart tag to let you know.