Formatting the X-axis and Y-axis in Excel 2007 Charts0

When charting values, Excel 2007 isn’t always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types, such as the 3-D Column chart or the XY Scatter chart).

If you’re not happy with the way the values appear on either the x-axis or y-axis, you can easily change the formatting.

1

Select the axis values you want to format.

Click the x-axis or y-axis directly in the chart or click the Chart Elements button (in the Current Selection group of the Format tab) and then click Horizontal (Category) Axis (for the x-axis) or Vertical (Value) Axis (for the y-axis) on its drop-down list. Be sure to select the axis values, not the axis title. Excel surrounds the axis you select with selection handles.

 Enlarge

2

Click the Format Selection button in the Current Selection group of the Format tab.

Excel opens the Format Axis dialog box containing the following tabs: Axis Options, Number, Fill, Line Color, Line Style, Shadow, 3-D Format, and Alignment.

3

Change the appropriate options on the Axis Options tab as needed.

These options include those that fix the maximum and minimum amount for the first and last tick mark on the axis, display the values in reverse order (highest to lowest), apply a logarithmic scale, display units on the axis (hundreds, thousands, and millions, and so forth) and divide the values by those units, reposition the tick marks on the axis, and modify the value at which the other axis crosses.

4

Click the Number tab and change the number formatting as needed.

For example, to select the Number format with the comma as the thousands separator and no decimal places, you select Number in the Category list box; then leave the Use 1000 Separator (,) check box selected and enter 0 in the Decimal Places text box.

5

Click the Alignment tab and adjust how the labels appear.

Indicate the new orientation by clicking the desired vertical alignment in the Vertical Alignment drop-down list box and desired text direction in the Text Direction drop-down list.

6

Click Close.

As you choose new options for the selected axis, Excel 2007 shows you the change in the chart. These changes are, however, set in the chart only after you click Close in the Format Axis dialog box.

Read More...

How to Name a Cell or Cell Range in Excel 2013?0

Microsoft Excel 2013 provides the feature of giving name to an individual cell or the range of cells. This function makes our work easier when we make formulas. In Microsoft Excel we can assign name to a cell, table, and constant, range of cells or formulas. With the help of creating names formulas can easily be understand and managed by ourselves.

Named ranges can also be used to handle abundant data in huger worksheets. We used these ranges in formulas rather than typing and showing the particular cells. When we give name to any cell or range, by default Excel uses an absolute reference for the name which is always according to us. We can view the reference in the new Name dialogue box.

Name of cell or range can be create and used in two different types those are defined name and table name. Defined name show cells, formulas, range of cells and constant while Table name exhibits the Excel table, which is a collection of data save in rows and columns.

Now in this article we will learn how to name a cell or range using New Name dialogue box, have to follow these steps

Name a Cell or Range by New Name dialogue box:

• Open Microsoft Excel 2013
• Select > Cell or Range which we want to name.
• Click > Formulas tab.
• Go to > Define Name button.
• New Name Dialogue box will appear, type the name for the reference.
• In the Scope edit box, Select > Workbook from drop down arrow.
• If we want to add any description, Enter in the > Comments box.
• Click > Collapse and Expand dialog button to select different cells and type equal sign(=) followed by the formula or any constant value.
• Finally Select > OK button.

Read More...

How to Assign Keyboard Shortcut to Symbol in Excel 2013?0

Microsoft Office 2013 brings the feature of keyboard shortcuts to the symbols in all of its applications. Every person know that some standard keyboard shortcuts not only increase the outcome but also enhance the typing speed overall. These shortcuts make our work easier and we insert symbols in spreadsheet by using shortcut keys. Like Word 2013 we also add keyboard shortcuts to symbols in Excel by using AutoCorrect feature. It is an easy method for assigning and remembering keyboard shortcuts for symbols.

In Excel 2013 when we want to insert any symbol and click > Insert tab, Go to > Symbol section and Select > Symbol, there is no down arrow which shows the symbols menu such as Word. No shortcut key and code present in the Symbol dialog box. If we want to customize the ribbon there is also no button of customization below the list of command in the Excel Option dialogue box.

With the help of this article we will assign the shortcut key to a symbol in Excel with some limitation by following these steps.

Assign Keyboard Shortcut to Symbol:

To do work with this restriction in Excel and assign a shortcut key to a symbol, put the pointer in a cell and use the Symbol button in the Symbols section of the Insert tab to select and insert a symbol, such as the British Pound sign.

• Select> Symbol which is present in cell and Copy to clipboard.

• Click > File tab.

• Go to > Options from left side of menu at bottom.

• Excel Option dialog box will open, Click > Proofing from the list.

• Click> AutoCorrect option from the Proofing screen.

• AutoCorrect window will appear.
• Mark a tick on the check box of Replace text as you type.
• In the Replace edit box, type the shortcut key from keyboard and In With edit box enters the Symbol.
• We enter BP in Replace and with £ symbol.
• Press Add button, this pair will add in our list.

• Finally Click > OK button.

Read More...

How to Change the Automatic Calculation and Multi-Threading Features in Excel 2013?0

In Microsoft Excel 2013 when any modification is done in the entries or in formulas of the worksheet, this application automatically execute the recalculations of present formulas. No doubt automatic calculation is effective feature but most of time it takes few minutes to fulfill the process. During recalculation process we don’t perform any other activity and have to wait for the completion of this action. This procedure consumes more time when worksheet is very long and consist on too much formulas.

To overcome this issue, Excel facilitates us by turning off the automatic calculations. This will save our time unless and until we finished the entering and changing the formulas in our Excel’s sheet. But if we don’t turn off this feature and have various processors in our PC then turn on Multi-Threading feature which help us to speed up the process of recalculation.

Now in this article we will learn how to change automatic calculation and multi-threading feature by following the particular steps.

Disable Automatic Calculation Feature:

• Open Microsoft Excel
• Click > File Tab.

• Go to > Option command in the menu from the bottom of left side.

• Excel option dialog box will open
•  Select > Formulas button also from left.

• Scroll down in box and reach > Calculations option.
• Check >Radio button of Manual instead of Automatic
• Automatic calculation feature disable.

Enable Multi-Threading Feature:

• Click > File Tab.
• Go to > Option command in the menu from the bottom of left side.
• Excel option dialog box will open
• Select > Advanced in the menu from left.

• Scroll in the box and Go to > Formulas Section.
• Click in the check box of > Enable multi-threaded calculation.
• Feature of multi-thread calculation enable.

Read More...

How to Protect a Document in Excel 2013?0

In Microsoft Excel 2013 we can protect our whole worksheet but now we can also secure our single sheet and cells present in it. When we finalize our worksheet by examine the formulas and proof read the data so we want to save it from the access of unauthorized person and unexpected changes.
 
In Excel’s worksheet cells may b locked or unlocked. Cells have two attributes Locked and Hidden.  In this application all cells are locked by default by they are not hidden. When Excel sheet is protected then these two characteristics play their roles. When worksheet is being protected then we have to unlock the cells. Locking and unlocking of cells is useless and have no effect unless and until worksheet is protected.

How we will learn how to protect Excel document by following this particular method.

Protect a Document in Excel:

• Open > Microsoft Excel
• Select > Sheet which we want to protect.
• Go to > Review tab.
• Click > Protect Sheet command from the Changes section.

• Protect Sheet dialog box will open.
• By default, Excel selects the check box of Protect Worksheet and Contents of locked cells at the top of the box.
• Moreover, Excel also chose the option of locked any unlocked cells.

• Type Password in the edit box of > Password to Unprotected sheet.
• After entering password, Click > Ok button.

• Excel opens the Confirm Password box, again enter the password in the > Re-enter Password to Proceed.
• Click > OK button or Press > Enter key.

Read More...

How to Apply Conditional Formatting In Excel 2013?0

Microsoft Excel 2013 announces the new feature that represents our data in different look that is conditional formatting. When we are working in long worksheets having a lot of rows and don’t understand which data is more important than other so for solving this issue we use Conditional Formatting feature. This feature applies colors, different rules, conditions and backgrounds to our worksheet cell’s content. With the help of this unique function we also highlight our cell’s name, date or show the difference between low, medium and high number values. Conditional formatting facilitate user for creating another method of data and make the worksheet easily understandable.

For creating our own conditional formatting we have to follow these directions.
Apply Conditional Formatting:
Select desired cells for applying conditional formatting rule.

Apply Conditional Formatting in Excel

• Go to> Home button
• Click > Conditional Formatting Command, A drop down menu will appear.
• Take the mouse pointer to the desired conditional formatting type and select the rule which we want. For example we want to visualize the value greater than $4000.

Excel Conditional Formatting Command

• Greater than dialog box will appear.
• Enter>desired values into the empty text box such as 4000
• Chose>Formatting style from the drop down menu from “With” edit box.
• We will select Green fill with Dark Green text for formatting.
• Then click> OK button.

Excel Greater than dialog 

• Conditional Formatting will be applied to selected cells.

Read More...