Question: How do I format how the text displays in a cell in Microsoft Excel 2011 for Mac? Answer: Select the cells that you wish to format. Right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Number tab. In the Category listbox, select your format. There are 3 ways to do this: 1. Define the Series names directly Right-click on the Chart and click Select Data then edit the series names directly as shown below. Can i put my external on my windows when it already is downloaded for my mac. You can either specify the values directly e.g. Series 1 or specify a range e.g. Create a chart defining upfront the series and axis labels Simply select your data range (in similar format as I specified) and create a simple bar chart. The labels should be defined automatically. Define the legend (series names) using VBA Similarly you can define the series names dynamically using VBA. A simple example below: ActiveChart.ChartArea.Select ActiveChart.FullSeriesCollection(1).Name = '='Hello'' This will redefine the first series name. Just change the index from (1) to e.g. (2) and so on to change the following series names. What does the VBA above do? It sets the series name to Hello as '='Hello'' translates to ='Hello' ( ' have to be escaped by a preceding '). To change the color of a single worksheet tab, right-click on the tab and move your mouse over the “Tab Color” option. A palette of Theme Colors and Standard Colors displays on the colors submenu. Click on a color to select it, or click on “More Colors” if you want a color you don’t see on the palette. You can also use the ribbon to select a color for a tab. Make sure the worksheet tab for which you want to change the color is the active tab. Then, make sure the Home tab is active on the ribbon. Click “Format” in the Cells section, move your mouse over “Tab Color”, and then click a color on the colors submenu. If you prefer using the keyboard you can press Alt, H, O, T in succession (pressed separately, one after the other–do not hold any of the keys down). Once you press “T”, you’ll see the colors submenu where you can click on a color to choose it, or you can use the arrow keys to move to the color you want and then press Enter. Once you’ve assigned a color to a tab, it’s displayed in a light gradient of that color when that tab is active. When the colored worksheet tab is not active, the color on the tab becomes a solid color. You can also apply color to multiple worksheet tabs at once, as long as it’s the same color. To change the color of two or more contiguous worksheet tabs, click the first tab you want to select and then press Shift and click on the last tab you want to select. Then, right-click on any of the tabs in the selected group and change the Tab Color as shown earlier.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |