0
You may be referring to the format painter button, which has a little paintbrush on it. What it does is take the formatting from one cell or a set of cells, and applies it to other cells. So if you do something like put a number into a cell, bold it, colour the cell red, format the number to 2 decimal places and change the font size, that cell will have that formatting. To do the same for other cells may take some time. So what you can do is first select that cell and click on the format painter button. Then you would select a range of cells that you want to apply that formatting to. It will immediately format all the cells to be the same as the original one. It won't change any numbers or formulas in those cells, just change the formatting. So it is painting the formatting of one cell onto other cells.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Which button formats data as a table in Excel?
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
What button does excel display after the paste button is clicked?
It displays several options about what you can paste, like everything, format only, formulas only, special format, etc.
What button allows you to color the background of selected cells in Excel?
For Excel 2007, it is the button that looks like a paint can tipped over. You will find it on the Home tab in the Font section. Another option is on the Home tab in the Cells section, under the Format option (Format Cells | Fill).
What does xlsx stands for?
..xlsx is a Excel 2007 format, whereas .xls is Excel 2003 or earlier. Excel 2007 allows you to save in multiple 2007 formats: ..xlsx - Normal Excel 2007 format ..xlsm - Macro-Enabled format ..xlsb - Binary format Save your files as 2003 under Save as Type and you should be fine.
What is Merge Styles button in Excel?
It allows you to combine elements of different styles together.
What button can obtain the average and total in Excel?
The Autosum buttons allows to you to total and average. It also allows you to do other functions.
What is the name of the button in excel that allows you to copy values with or without formatting?
Paste Special allows copying with or without formatting
What is a tab scrolling button in Excel?
button that appears just to the left of the sheet tabs, which allows you to scroll hidden tabs into view.
What button in excel allows you to view the page in larger or smaller sizes in the preview window?
ZOOM
Currency style button in found in which tool bar in Microsoft Excel?
There is no currency style button. You can navigate to the format currency style option like this:Ribbon = HOME | Item = Format | Menu = Format Cells | Tab = Number | Category = Currency
What Excel button lists formatting options?
Insert Options
How do you export data from a query to Excel?
Create the report in a tab delimited format. It may have a suffix like txt or rpt. In Excel use the "Open" command. You will get a panel that allows you to refine where the column breaks are and define the format of the columns. Once this is done the data will be in Excel. Just save as a standard Excel file.
