HAPPY NEW YEAR everyone and may all your resolutions come true….
Like this blog post? Buy me a coffee or send me a tip!!!Posted under Twitter post
This post was written by HarryDelgado on December 31, 2008
Navigating In Microsoft Excel 2007
Each Excel document is referred to as a workbook and each workbook can contain up to 255 worksheets. To activate a particular worksheet, click on one of the tabs displayed at the bottom of your screen.
To the left of the tabs will find four navigation icons. These are very useful where you have a workbook that either contains lots of worksheets or has worksheets with very long names. The very first button makes the name of the first worksheet visible; the very last button makes the name of the last worksheet visible. The left pointing arrow button makes the name of the previous worksheet visible and of course the right pointing arrow button makes the name of the next worksheet visible. These four buttons don’t actually activate a worksheet; they simply make its tab visible. To activate a worksheet, you still have to click on that particular name tab.
Worksheets can also be activated using the keyboard. To activate the next worksheet to the right, hold down Control and press the Page Down key. This moves you forward through the worksheets are naturally holding Control and pressing Page Up moves you back to the left.
Once you have navigated to a particular worksheet, you will need to go to a particular cell or a particular section of that worksheet. Firstly, you can use the scrollbars to make different parts of the worksheet visible. Secondly, you can move around the worksheet using the arrows on your keyboard: down, right, up and left.
Excel also has some useful keyboard shortcuts for moving to the edges of a given body of data. To get to the right-most cell of your current range, hold down the Control key and press the right arrow key and of course to get to the bottom cell, hold down Control and press the down arrow.
It is also possible to do exactly the same thing with the mouse. Position the cursor on one of the edges of the selection rectangle (that bold highlight which is displayed around the currently active cell) and then you simply double-click. Double-clicking on the right hand edge of the selection rectangle takes you to the extreme right of the current range. Double-clicking on the bottom edge jumps to the bottom of the range, and so forth.
There are two final navigation key combinations which should be mentioned: Control-Home and Control-End. Hold down the Control key and press the End key to move to the bottom right of the current range. Hold down Control and press Home to move to the top left of the current range.
As well as navigating through worksheets, most Excel users make frequent use of the Ribbon. Excel offers a series of handy keyboard shortcuts when working with the Ribbon.
To access Ribbon keyboard shortcuts simply press the Alt key once. A series of numbers and letters is then displayed. These represent the shortcuts that you should type to activate that part of the Ribbon. For example, “W” is the shortcut key for activating the View Tab.
When you press “W”, the View Tab is activated and another series of badges is displayed on each of the commands within the View Tab. For example, the “Arrange All” command uses “A” as its keyboard shortcut, so simply typing “A” is equivalent to clicking the Arrange All button.
Once you’ve typed a letter to execute a command, the Ribbon loses focus and the shortcut badges disappear. To access Ribbon commands via the keyboard once more, simply press the Alt Key and the badges will reappear. This means that you never have to worry about learning keyboard shortcuts. All you have to remember is to press the Alt key on your keyboard and Excel will prompt you from there.
About the Author:
The The writer of this article is a trainer and developer with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel 2007 Classes in London and throughout the UK.
Posted under Software
This post was written by Andrew Whiteman on December 31, 2008
Buying Apple Refurbished and Used Mac Laptops is a Wise Choice
Apple refurbished and used Mac laptops are a great option when considering buying a computer. Whether you are looking to upgrade from the computer you already have, trying to meet business or personal needs or have a student in need of a system for schoolwork a refurbished Macintosh computer is a smart choice. It will meet all your technical needs as well as be easier on the pocketbook.
Lets face it; we all want the best value for our dollar. And refurbished computers provide just that. These computers are often never used, having been ordered but not shipped or having been returned without even being turned on. The computers that were used are put through rigorous testing and must meet the same standards as any new computer leaving the plant. All your computer needs can be easily met with a refurbished Mac laptop. Anything that you want to do with your computer, from CAD projects to playing your favorite movies to all your business accounting can be done just as professionally and easily on a used computer ordered through Apple as it can on a new one and for half the price.
You can get refurbished Apple laptops with features that you will not find on a new PC and you get amazing support with your purchase. There are all the same options available in refurbished models as you can with brand new ones, wide screen glossy monitors, built in cameras and lots of great software already for you to use.
Refurbished and used Mac laptops sold through the online Apple site also come with technical support and a warranty just like new computers. You can shop from the comfort of your home, see all the options available, get customer service, and have it delivered to your door all for a much lower price then you will find anywhere else.
The Apple site is simple to use and answers even the most perplexing questions any time of day from anywhere you want. You can buy a quality computer in the middle of the night while wearing your pajamas or on your lunch hour at work. It is a quick, secure, and straightforward process that caters to the needs of every customer.
Once you find the refurbished computer that suits your needs there are lots of support available to you from on site customer service by knowledgeable employees of Apple to an owners manual that will be shipped with your computer. You will have all the technical support available and can even purchase the appropriate features that will be perfect for you. Apple has the highest standards for each computer to make sure that it will be as problem-free as any new computer you might find yet is easy on your budget as well. There is no excuse to keep putting off getting the computer you always wanted.
Apple refurbished and used Mac laptops are a great answer to anyones computer and technological needs. There is a product available to meet even the pickiest of customers needs and Apple offers them all from their client friendly site. There is no need to put off getting the computer you have always dreamed of because Apple refurbished and used Mac laptops are the top of the line and most economical choice available today.
About the Author:
What you just learned about Hyper Dash Race Course Game is just the beginning. To get the full story and all the details, check us out at Refurbished Mac Laptops. ###
Posted under Hardware
This post was written by Harley Hamilton on December 31, 2008
