Microsoft Excel 2013 includes shapes that illustrate or draw attention to specific data on your Excel worksheet. Customize these graphic elements with the Drawing Tools and format options. I used to be able to just draw a line in my spreadsheet (similar to PPT), but can not figure it out now. Any solutions? How do i draw a line in excel 2011. This used to be in the drawing toolbar. Excel / Mac / Office 2011 for Mac; Answer Jim Gordon MVP Replied on November 2, 2011.

Excel provides another method for creating borders around cells. Instead of selecting cells first, and then applying a border, you can instead select a border tool, and draw borders directly on the worksheet. Let's take a look. Near the bottom of the border menu on the home tab of the ribbon, is a group of commands for drawing borders. Excel has two basic modes for drawing borders - 'draw border' and 'draw border grid', and another mode for erasing borders called 'erase border'. To draw a border, first select a color and a line style. Notice that once we select either of these options, Excel shifts into 'draw border' mode - the Draw Border menu item is selected, and the the cursor changes into a pencil.

In 'draw border' mode, you can draw a border along any gridline. We can use this flexibility to draw an irregular border. While this could be done in multiple steps, using the format cells dialog box, it would be tedious. With 'draw border' enabled, you can also click and drag to create a rectangular border around any block of cells. Now let's look at the second border drawing mode - 'draw border grid'.

In this mode, Excel will create both outside and inside borders at the same time. When following a gridline, 'draw border grid' works like 'draw border', adding a single line.

However, when you click and drag across cells, 'draw border grid' creates borders around all cells that are part of the selection. To stop drawing borders, just click the border button on the ribbon. This disables the current drawing mode. This button remembers the last drawing mode used. When you click it again, that mode will be re-enabled. Now let's look at how to erase borders.

First select 'erase border'. With this option enabled, it's possible to remove borders one at a time by clicking each border individually. It's also possible to click and drag over cells to remove their borders.

How to Make a Trendline Graph in Techniques in Excel 2008 for Mac Users Basic Functions in Excel 2008 1. Main Toolbars: There are three main toolbars we will be using for LSP 120. The first is bar at the top of the screen that has drop down menus.

The second is the Gallery, which you will use to create graphs. You can open the Gallery toolbar on your screen by clicking the button at the top. The last toolbar is the Toolbox. You will use the Toolbox to format graphs and to find functions like PMT and MAX. You can open the Toolbox by clicking the button at the top.

Summation and Sorting: These buttons are at the top of the screen and work the same as in Excel 2007/2003. You can also sort in this way: First select and highlight your data. Microsoft wireless gaming receiver for windows to use your wireless controller in mac os x!. Then go to the the Data menu at the top of the screen and select Sort from the drop down menu.

Paste Special: Since Macs cannot 'right click,' you can access Paste Special by going to the Edit menu at the top of the screen and selecting Paste Special from the drop down menu. A special note when Transposing: There are sometimes problems with this if you have a graph or other images in your worksheet.

If you have a graph in your worksheet, first copy the data to a new worksheet, then transpose. Mac eject button on pc keyboard. PMT Function: You can access the PMT function by using the Toolbox.

Select the Format Builder section of the Toolbox. Either look up PMT or find it on the list under Financial. Double click on PMT. You will enter your information into the Format Builder. (This is also where you can find the MAX function.) 5. Other Special Notes on Excel 2008: • Freezing Cells: Macs do not have an F4 key, so to freeze manually you need to put a dollar sign ( $) before the letter and number of the cell you are freezing.

For example, if you wanted to freeze cell B23, you would type $B$23 into your equation. • Highlighting Non-Adjacent Cells: On a PC you will use the Control key to highlight non-adjacent cells, however it is not the same for a Mac. On a Mac you should instead hold the Apple key when you wish to highlight non-adjacent cells. How to Make a Trendline Graph in Excel 2008 1. Select the data. To select the data for your graph click on cell A9, and then drag your cursor (it should be a thick cross) to cell B29. Choose a chart type: In the Elements Gallery, click the Charts tab.