enter

We recently received this question from a regular Infopackets reader: "Hi there, Thanks for all the great information you've been supplying me. Now I have a question: I'm a Windows 8 user who has never really appreciated the log-in prompt. Is there ... a way to disable it on my computer? Thanks! John C." My answer: Yes, John, there is. Windows 8 users who don't like the log-in screen can bypass this part of the normal process when starting up their PCs. Ending Log-In Prompts in a Few Easy Steps To get rid of the usual Windows 8 log-in, first boot up your computer and enter your log-in ... (view more)

There are a number of way in which you can copy formulas in MS Excel. You can use the Autofill feature or select the cells you want to copy to, enter the formula in the active cell and press Ctrl + Enter. These methods work very well for you in ... Excel unless you have hundreds of rows that you would like to copy. Let's say you have 100 classes listed in Column A of your spreadsheet and Column B lists the in-state tuition price of each class. Wouldn't it be nice to enter a formula that calculates the price for each class and displays the results in Column C? The practice of selecting hundreds of ... (view more)

The default behavior of the Enter key in MS Excel drives some folks crazy. When you click on Enter, some people would prefer that the cursor move to the next cell on the right, while others prefer the cursor move downward. Fortunately, MS Excel can ... accommodate these preferences and more. To change the way MS Excel reacts after you click Enter, follow the steps below: Click on Tools | Options. Click on the Edit tab. Click the Move Selection After Enter check box to activate the direction drop-down list. In the drop-down list, select from the following options: Down Right Up Left If you prefer ... (view more)

MS Excel formats date and time values in a way that is meaningful to us, such as 12/01/08; December 1, 2008, 2:15 p.m., 12/01/08, 14:15, etc. With just a quick glance, we know precisely what the date and time string represents, but internally MS ... Excel uses a serial value, not the formatted value that we see. When working with time and date values, it can be very beneficial to know the serial value and Excel makes it easy for us to have a quick look and see. Follow the steps below to learn how: Enter some date and time values: Click CTRL + ; to enter the current date. Click CTRL + Shift + ; to ... (view more)

It can be daunting and more than a bit frustrating when the CEO of your company dumps a ton of data on your desk and expects you to hastily turn it into an MS Excel database. But it doesn't have to be daunting any longer -- it can even be easy using ... the Data Entry Form in MS Excel. This handy feature will allow you to enter an entire row of date all at one time, rather than entering each little bit of data one at a time. Sounds a lot better already doesn't it? So we have now established that data entry forms in MS Excel definitely bear investigating eh? Follow the steps below to learn how. To ... (view more)

Many times, in an office setting, you have an Excel spreadsheet that has to be sent to different departments on a weekly basis. Even if you have a distribution list setup in MS Outlook, it still takes some time to setup your e-mail and proof it ... before sending it out. Why not let MS Excel do it for you? Follow the steps below to lighten your workload: Launch MS Excel if it is not already open. Open the workbook containing the report you want to send. Click ALT + F11. The Visual Basic Editor will open. In the Project-VBA Project pane, double-click ThisWorkbook. Go to Insert | Procedure. Click ... (view more)

Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row. Unfortunately, MS Excel does not ship with an autonumbering feature (like that found in MS Access), that increments a number each time you ... add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list. Say you want to create a list of all of your school's classes and their corresponding learning materials. Follow the steps below to add autonumbering to the list: In A1, enter the formula below: =TEXT(Row(A1),"000-000") Enter the name ... (view more)

The default behavior of the Enter key drives some Excel folks crazy. When you press Enter, some users would prefer that the cursor to move to the next cell on the right, while other folks prefer the cursor to move down. Fortunately, MS Excel can ... accommodate these preferences and more. To change the way Excel reacts after Enter is pressed follow the steps below: Go to Tools | Options. Select the Edit tab. Click the Move Selection After Enter checkbox to activate the Direction drop-down list. In the drop-down list, select from the following options: Down Right Up Left If you prefer that the ... (view more)

Sometimes bulleted lists are difficult to read. When bullet items have more than two lines of text (which frequently happens when writing instructions), it would be nice to have bullets that are have more space between them. I find that as I age my ... ability to read items that are close together is lacking. One way is to enter a bullet item, press enter (to go to the next bullet item), then press enter again, enter the text for the bullet item, and then return to the extra bullet and pressing Backspace to remove it. That seems like quite a few key strokes don't you think? A better solution ... (view more)

Now that the holiday season is rapidly approaching, it's a good time for some quick reminders about safely purchasing items online. Armed with the proper knowledge and a little common sense, purchasing things online can be as safe as going to the ... store and purchasing it in person. It's getting easier to purchase items online from reputable companies. However, there are also several "companies" that want to steal your personal and financial information. Listed below are some suggestions for making your online shopping experience more enjoyable. Contact Information Is the sellers address and ... (view more)