Category: 

What is an Active Cell?

Article Details
  • Written By: H. Bliss
  • Edited By: W. Everett
  • Last Modified Date: 19 September 2016
  • Copyright Protected:
    2003-2016
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
The atmosphere of Jupiter's moon Io collapses every time it is eclipsed by the planet.   more...

September 29 ,  2008 :  The Dow Jones Industrial Average experienced its largest one-day drop in history.  more...

An active cell is a cell in a computer spreadsheet that is selected for manipulation. It is identified by a thicker outline on the cell that was last selected by a cursor. Within spreadsheet programs like Microsoft Excel® and OpenOffice.org® Calc, cells hold the data that makes up the spreadsheet. When selected as an active cell, a cell can be manipulated and changed in a variety of ways.

Versatile segments of information, cells can be altered in many ways to best fit the purpose of the spreadsheet. For appearance purposes, spreadsheets can be merged, colored, outlined, or resized. Merging cells means that the line between them disappears and the multiple cells act as one single cell. Merging cells can be beneficial for adding a title or text section to a spreadsheet or for highlighting a cell with important or final information.

A cell is the name for one of the individual boxes in a spreadsheet. To make it active, a user selects the cell with the mouse cursor. Cells can be resized and moved and individual cells, rows of cells, or columns of cells can be added to a spreadsheet if more space is needed.

Ad

Within spreadsheets, cells can be programmed to handle different types of data, including specific types of data formatting or formulas which make automatic calculations from data entered on the spreadsheet. Data formatting of an active cell can be used to tell the cell to handle data as if it were a certain type of data, like currency, percentages, fractions, and dates. This function is especially useful when formatting a spreadsheet to create a chart.

Adding color to an active cell can help distinguish it from other cells on the spreadsheet. This can help a special piece of information stand out when presenting the spreadsheet or sending it to other people who only need specific information on the spreadsheet. By highlighting special information with color, a spreadsheet presenter can ensure that important information is easily accessible to anyone reading the spreadsheet.

Including a spreadsheet within a document can provide a platform for explaining the spreadsheet that can make it easier for readers to understand. Many spreadsheet programs allow the user to select an active cell or groups or active cells and paste them into other programs, like word processors. This way, the active part of the spreadsheet can be included within a document that has text pertaining to the spreadsheet.

Ad

You might also Like

Recommended

Discuss this Article

Post your comments

exception 'Exception' with message 'error writing captcha: Duplicate entry '2147483647' for key 'PRIMARY'' in /ssd/www/wisegeek/public_html/_core/classes/public/Captcha.php:44
Stack trace:
#0 /ssd/www/wisegeek/public_html/_core/controls/public/ControlDiscussionPostBox.php(324): Captcha->createCaptcha()
#1 /ssd/www/wisegeek/public_html/framework/classes/Control.php(104): ControlDiscussionPostBox->preRender(false)
#2 /ssd/www/wisegeek/public_html/framework/classes/Control.php(149): Control->render()
#3 /ssd/www/wisegeek/public_html/tpl/default-nocustom-lu/pages/public/article/article.htm(526): Control->__toString()
#4 /ssd/www/wisegeek/public_html/framework/classes/Control.php(300): require('/ssd/www/wisege...')
#5 /ssd/www/wisegeek/public_html/framework/classes/Control.php(309): Control->requireTpl('pages/public/ar...', Object(PageArticleCom), true)
#6 /ssd/www/wisegeek/public_html/framework/classes/Control.php(131): Control->renderTpl('pages/public/ar...', Object(PageArticleCom))
#7 /ssd/www/wisegeek/public_html/framework/classes/FormDataControl.php(87): Control->renderTemplate()
#8 /ssd/www/wisegeek/public_html/framework/classes/Control.php(109): FormDataControl->renderTemplate()
#9 /ssd/www/wisegeek/public_html/framework/classes/ScriptPage.php(50): Control->render(false)
#10 /ssd/www/wisegeek/public_html/framework/classes/Control.php(149): ScriptPage->render()
#11 /ssd/www/wisegeek/public_html/framework/classes/Page.php(97): Control->__toString()
#12 /ssd/www/wisegeek/public_html/_core/classes/public/PublicFrontController.php(443): Page->processRequest()
#13 /ssd/www/wisegeek/public_html/_core/classes/public/PublicFrontController.php(7): PublicFrontController->renderPage()
#14 /ssd/www/wisegeek/public_html/index.php(11): PublicFrontController::run()
#15 {main}