Tip: To add or remove parts of a border, click More Borders at the bottom of the menu. Under Border, click the borders that you want to add or remove. Remove all cell borders • Select the cell or range of cells where you want to remove the borders. • On the Home tab, in the Font group, click the arrow next to Border, and then click No Border. Create a custom border Use cell styles to create a custom border that you can easily apply over and over again. • On the Home tab, in the Styles group, click Cell Styles, and then click New Cell Style. Question: How do I change the background color of a cell in Microsoft Excel 2011 for Mac? Answer: By default when you create a new workbook in Excel 2011 for Mac, all cells will be formatted with a background color that is transparent. This allows you to see the grid lines in the worksheet. You can change the background color of any cell to enhance the look of your document. • In the Style name box, type a name for your new cell style. • Click Format. • Do any of the following: To Do this Choose a custom border line style On the Border tab, under Line Style, click the line style that you want to apply, and then under Border, click the specific pieces of the cell border to apply the line style to. Choose a custom border line color On the Border tab, under Line Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. Tip: To add or remove parts of a border, on the Home tab, under Font, click Border, and then click Border Options. Under Border, click the borders that you want to add or remove. Remove all cell borders • Select the cell or range of cells where you want to remove the borders. • On the Home tab, under Font, click Border, and then click No Border. Create a custom border Use cell styles to create a custom border that you can easily apply over and over again. • On the Home tab, under Format, point to a style and then click. • Click New Cell Style. • In the Style name box, type a name for your new cell style. • Click Format. • Do any of the following: To Do this Choose a custom border line style On the Border tab, under Style, click the line style that you want to apply, and then under Border, click the specific pieces of the cell border to apply the line style to. Choose a custom border line color On the Border tab, under Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. ![]() ![]() This question is still unsolved. How do you DRAW a line in Mac Excel 2011? [New question split by moderator from a question about how to draw or erase borders, not lines] How do i draw or erase a border in Excel 2011 - Microsoft Community -------------Problems Reply------------ I did finally find the tool I was looking for. Not sure how to link this discussion to that one but here's the web address: You pick a tool in the media browser. This is the icon with the music note symbol, Or use Insert-Shape from the menu. See the Excel section of this Office 2011 Help article. That does not seem very intuitive. Look for a drawing tool in the 'Media Browser'. No wonder so many people have a hard time finding it. What I am looking for is this: Then what you're actually looking for is the Draw Border tool which is not included on any of the built-in toolbars or any of the Ribbon tabs in Excel 2011. The tool can be added to built-in as well as custom toolbars if you wish along with other tools related to Borders. There also is an Apply Border tool on the Home tab just to the left of the Fill Color tool. It also has a listing for Border Options that brings you the Format> Cells - Border dialog which is the source of the Borders feature as described in: Add, change, or remove cell borders Thank you for sticking with me. I haven't used Excel for several years and this new version is driving me crazy. I search for answers and get answers that appear to be given to some one familiar with the menus and that I am NOT! Now I'm having a problem with multiple windows. I have a document I have been working on with 2 sheets side by side. One is labeled xzy.xlsx:1 and the other xzy.xlsx:3. Every time I open the file I get the same 2 windows back. What is Excel doing here? I searched on Microsoft Community for an answer and got these responses: EXEL FOR MAC DOESN'T PRESENT CSV FILES THE SAME WAY AS EXEL FOR WINDOWS Hi I recently switched to Mac and purchased Exel for Mac as I download and manipulate a CSV file daily. When the CSV file is opened in EXEL for MAC, the fields are not organized in 8 columns (as if Question| Answered| 2 replies| Last reply September 21, 2011 Why is the saving window in the left corner? In Excel 2011 (v 14.2.2) why is the saving window sometimes in the left corner? Click here to see the picture. Question| Answered| 8 replies| Last reply February 23, 2013 Can you help me with this one? Somewhere along the line Excel has been told to display the 2nd window [Window> New Window].
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |