Excel Format Painter – multiple instances

Q. Can "Format Painter" MS Excel be used to apply formats to different places without having to click on the Format Painter icon multiple times?

A. Yes it can done by double clicking on the Format Painter icon.

Answer in details:

Format Painter in MS Office is a tool to copy format of selected area and apply it in the new area. For example, in the following screen shot, three different cells have different text styles and background colors. If I want to copy the same format in other three cells, all I can do is:

• select the source cells
• click on Format Painter icon on excel tool bar (ribbon)
• click on first cell of the destination (or drag to select all three of destination cells).

–>

You can see how the font, background change while the content remain the same.

Read the rest of this entry »

Incoming search terms:

• how format painter in excel multiple times
• excel multiple format painter
• excel format painter
• excel format painter multiple times
• excel 2010 format painter multiple cells
• format painter u exelu
• how to use format painter for multiple items in excel
• lock format painter
• ms excel format painter
• multiple format painter cells

Shutdown automation, shutdown after given time

In a Windows machine there is a command to shutdown a computer after certain time interval.

For example, if you want to shut down your computer after an hour you can give a command in the command windows:

"shutdown -s -t 3600"

-s for shutdown
-r for restart
-t for time

In Windows XP the procedure is:

1. Start –> Run

2. Type the command with the time in seconds

3. Let the computer shut down

There is another option to schedule shutdown by Task Scheduler in the Control Panel.

Incoming search terms:

• command to shutdown pc after 1 hour
• tech on the net why do a shutdown on pc
• shutdown xp after certain time
• shutdown windows xp after time
• shutdown windows
• shutdown
• powershell delete user control userpasswords2
• how to shutdown computer after 1 hour windowsw xp
• how to make computer shutdown after an interval of time
• how to do a shutdown windows xp in one hour