Move around the cells in your workbook without touching your mouse using the Up and Down and Left and Right Arrow keys. To jump to the edge of the current block of data press Ctrl + the appropriate arrow key – so to move to the last row press Ctrl + Down Arrow.
Labels: 2010, Excel, how to, microsoft excel, navigate cells, tip, trevor office, trevor payne
Categories:office, trevor tip
Sometimes you need to place a copy of a worksheet or a picture of an Excel chart onto your website or into a document. When you need only the image itself (not the link or an embedded version of the worksheet) you can make a copy of the area or graph as a picture.
So, with the worksheet open, select over the area that you want to convert to a picture. Or, if you need a picture of a chart select the chart. Now, from the Home tab, click the Copy dropdown list and choose Copy As Picture.
From the dialog which appears, choose Bitmap if you want an image the same size as you see it on the screen. To get an image you can make larger than this, choose Picture as this creates an image which scales well.
Then select either ‘As shown on screen’ or ‘As shown when printed’ as required. Click Ok and the picture will be copied to the Windows Clipboard. You can now paste the image into another application using that application’s Paste tool.
Labels: 2007, 2010, convert chart to image, copy as picture, Excel
Categories:Uncategorized
Excel 2007 & 2010 come with a number of add-ins that you can get to by choosing the Options button (File in Excel 2010) and choose Excel Options (Options in Excel 2010) and click Add-ins. From the Manage dropdown list choose Excel Add-ins and click Go.
A list of available Add-ins appears in the list. Any that don’t have their checkboxes checked aren’t enabled right now.
One you might want to enable is the Analysis Toolpak – this gives you access to functions like RANDBETWEEN and NETWORKDAYS. There’s also possibly a Lookup Wizard (in Excel 2007 only – it was discontinued in Excel 2010) and a Solver add-in in the list.
Click on any of the Add-ins to add them to Excel. Once you do, they’ll be available every time you launch Excel.
RANDBETWEEN is a handy function for filling cells with a random value. It’s syntax is RANDBETWEEN(startvalue, endvalue) so to fill a range with values between 100 and 200 use =RANDBETWEEN(100,200) then copy it to the range to fill. You can read more about the function here: Random numbers in Excel.
NETWORKDAYS will calculate the number of working days between two dates. You can read more about this function here: Excel – calculating workdays with Networkdays.
Labels: 2010, Add-ins, analysis toolpak, Lookup Wizard, Microsoft Excel 2007, NETWORKDAYS, Randbetween, Solver add-in
Categories:Uncategorized
