Skip to main content

Posts

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts.  Mouse shortcuts: Shortcut Description Double-click (on a cell) Edit the cell contents. Double-click (on a row/column divider) Adjust height/width to auto-fit High-light headers of multiple rows/columns then Double-click on a row/column divider Adjust height/width to auto-fit of all high-lighted rows/columns Triple-click Select the entire contents in the cell Click on row/column divider then drag Adjust height/width of the row/colunn High-light headers of multiple rows/columns then Click on row/column divider then drag Adjust height/width of the rows/colunns Ctrl + Mouse wheel Zooms in and out of document. Hold Shift + Click the cells Select multiple cells Keyboard shortcuts: Shortcut Description F2 Edit the selected cell. F5 Goto a...

Windows XP Secrets

I am  sharing some secrets of Windows XP. These secrets may or may not apply to newer Windows Operating Systems. Notepad Secrets Create a log Open Notepad On the very first line, type in " .LOG " (without quotes) then press Enter for a new line Now you can type in some text if you want, then save the file. Next time when you open the file, notice its contents. Notepad automatically adds a time/date log everytime you open the file. Text becomes unreadable Open Notepad On the very first line, type in " dont eat the donut " (without quotes) then save and close the file. Note : the file should have only one line of the text above. Now, open the same file. You'll notice the text becomes unreadable squares. (try this with different text with the same format and length). Paint Secrets Create a trail image Open Paint , then open an image. Right-click on the image and select " Select All " Now hold the ...

Don't just maximize your windows—go full screen

When you need a really big window for viewing photos and videos, don't just maximize it: go full screen! This tip works great for viewing photos and videos at maximum size in Windows Explorer or Windows Media Player, utilizing screen space usually occupied by the header at the top of the screen and the taskbar at the bottom. Here’s how: Open any photo in Windows Explorer, or open a photo or video clip in Windows Media Player. Do one of the following: In Windows 7 and Windows XP, click the F11 key at the top of your keyboard. The photo or video image enlarges to its maximum size and the title bar and taskbar are hidden. To undue full-screen mode and restore the window to its normal view, press the Esc (Escape) key at the top of your keyboard

Add Safe Mode to Boot Menu

Safe Mode is most commonly used for troubleshooting purposes.  If you find yourself booting to safe mode often. You may find it helpful to include the option for safe mode in your boot menu. Below, is a method you can use to save yourself from having to press F8 during startup to access Safe Mode: Right click My Computer and click Properties. Click the Advanced tab. Under Start Up and Recovery, click the Settings button. Click Edit. The boot.ini file will open in Notepad. Copy the line that reads as follows: multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Microsoft Windows XP Professional" /fastdetect. Paste the line you just copied after the original one. Change the copied line from "Microsoft Windows XP Professional" to "Windows XP Safe Mode" or something similar. At the end of this line add the following: /...

Windows 7 trick:How to add recycle bin icon on your taskbar

For a while now, I’ve been hiding my desktop icons and using a taskbar toolbar instead. It’s a lot tidier, and one somewhat useful benefit is having the recycle bin always close at hand — without having to windows + D.   The only downside to using the desktop as a taskbar toolbar is that the recycle bin won’t move in front of Libraries or your user folder. If you want the bin in full view, you’re stuck displaying at least three icons — two of which you don’t need if you already have Explorer pinned. If you use the QuickLaunch (or any custom folder of your choosing), you can simply drag the recycle bin icon off your desktop, onto the toolbar, and ba-da-bing, you’ve got a functioning bin like the one in my screenshot.   Here’s the short and sweet way to pull this off: Right click in some empty space on your taskbar and choose toolbars -> new toolbar from the menu Paste   %userprofile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch   into th...

Moving The Taskbar

I bet you didn't know that you could move your taskbar if you wanted.  Mostly I leave mine at the bottom, like the rest of the population, but occasionally I feel like going wild and have the taskbar at the top of my computer.  The Taskbar is that thin bar at the bottom where you can see all your open programs, the start menu, the clock, etc.  Now, in WinXP they made it very nice to move it.  This is how: Right Click on the Taskbar Click, Lock the Taskbar, until there is no check there Left Click on the task bar and move it to where you want it...it will always rest up against an edge, so top, left or right. Then ...

Add Watermark to an Excel Document

Unfortunately, the printed watermark feature is not available on any version of Excel (including Excel 2007, 2010). However, there are some workaround methods to add text or images into an Excel document that would result something similar to a watermark. The followings are examples of Excel Documents with text and image "watermark": Step-by-step procedure to add a watermark to an Excel document (applied for Microsoft Word 97-2010): A. TEXT WATERMARK:   The trick is to place a WordArt on the background of the Excel sheet.   Microsoft Excel 97/2000/XP (2002)/2003: Open the Excel document that you want to add watermark to. Select " Insert " from the top menu, then select " Picture " > " WordArt... ". In the " WordArt Gallery " dialog, select a WordArt style that you like then click " OK ". In the " Edit WordArt Text ...