Using Task Panes in MS Excel

Task pane is another useful user interface in Excel. Some commands in Excel will respond automatically with task panes. For example, if you work with a picture, and right-click the image and choose Format Picture, Excel will display the Format Picture task pane. The task pane is similar to a dialog box except that you can keep a task pane visible as long as you want.

Using task panes in Excel

Task Pane in Excel. Format Picture task pane. Select and right-click on an Image ⇒Format Picture…

A new feature in Excel 2013: The role of task panes has increased dramatically in Excel 2013. For example, if you work with a chart, you can access a chart related task pane that has an extensive number of commands for every element within the chart

Using some task panes is not so easy. The Format Picture task pane has four icons- Fill & Line, Effects, Size & Properties, and Picture. The names are shown when you hover your mouse pointer over the icons. For example, click an icon and you will find a command list below the icon tab. Click a command from the list and you will be shown some options in drop-down style for that command.

Using task pane in Excel

Task pane in Excel. Format Picture task pane⇒Effects⇒Shadow

Navigating within a task pane

There’s no OK button in a task pane. If your job is done with a task pane, click the Close button (X) in the upper-right corner. Using the task pane through the keyboard is simple. Just make sure that the task pane is displayed in your workbook and press F6 to activate the task pane. Then use the tab key, the arrow keys, the spacebar, and other keys to navigate within the task pane.

Read More: Working with Dialog Boxes in Excel

The position of the task pane in the worksheet

By default, the task pane is placed on the right side of the Excel window. If you want, you can move it anywhere you like, by clicking its title bar and dragging it. You can also use the ‘Task Pane Options’, an icon beside the ‘Close’ button. There are three options here-Move, Size, and Close.

Using task pane in Excel

Task Pane Options

Task Pane in the different place

Excel will remember the last position of your task pane, so when you will use the task pane next time, it will be right there where you left it.

Using Task Pane in Excel

Task pane moved to another place.

Tips: You can’t navigate within a task pane through the keyboard using Tab, Spacebar, the Arrow keys, and ALT keys like you use to navigate within a dialog box. First of all, you have to activate the task pane by pressing the F6 key. Then use Tab, Spacebar, the Arrow keys, and Enter from your keyboard to navigate within a task pane.



Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy:

We will be happy to hear your thoughts

Leave a reply