A group of cell is called tissue. A tissue is a group of cells of common origin which are structurally similar and perform a particular function. The cell is the most basic structural and functional unit. Groups of tissues make up organs in the body such as the brain and heart. Show Plant tissue is made up of a group of cells and the types are listed below The location of a cell on a worksheet is given by its column letter and its row number (e.g. "A1"). This is often referred to as the Cell Address. Colon ( : ) - This is used to define a range of cells (e.g. "A1:D4"). A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon. Comma ( , ) - This is used to define non adjacent cells (e.g. "A1", "B2"). The comma is also known as the union operator. Space ( ) - This is used to combine the intersection of two blocks of cells (e.g. "A1:D4 B2:C3"). When you use this operator the two blocks of cells must overlap. If not then an error message will appear. The space is also known as the intersection operator. Multiple cell ranges are commonly known as non adjacent or non contiguous ranges. These are ranges of cells that are not in a nice rectangular block. Entering dataYou can enter three different types of data into cells. This is sometimes expanded to four as some people class Dates & Times as a separate type. If you are not able to edit the contents in the cells directly then check your (Tools > Options)(Edit tab, "Edit directly in cell"). Selecting DataBefore you can enter data into a cell you must select the cell first. There are a large number of shortcut keys that can help you to select data and probably the most useful is (Ctrl + Shift + 8) which selects the current region. Moving dataWhenever you copy cells, Excel stores the data in a temporary memory called the clipboard.The data will stay there until it is replaced by some other data. It will only get replaced with a subsequent Cut or Copy command. The shortcut keys (Ctrl + C), (Ctrl + X) and (Ctrl + V) correspond to copying, cutting and pasting data respectively and are consistent with other applications. You can alternatively just press Enter to paste the current entry from the clipboard. Sorting dataThere are a number of ways you can sort and rearrange your data.You can sort by rows or columns into ascending and descending order.When you sort by rows the columns remain in the same order and the rows are rearranged.You can define your own custom sorting sequence regardless of their alphabetical sequence.It is important to remember that numerical values are sorted ahead of text values. There are four custom lists that exist by default and these contain days and months. If you sort by a column that contains entries from one of these four custom lists then they will be automatically sorted into the correct chronological order (i.e. Mon, Tue, Wed or Jan, Feb, Mar, etc). Deleting dataWhen you want to erase the contents of a cell, use the (Edit > Clear) menu rather than deleting the actual cells.Alternatively you can press the Delete key. This will ensure your formulas and number formatting remains intact. Displaying DataSometimes if a number starts with a negative sign then they are only displayed as a dash if the column width is not wide enough for the whole number. Just F2 the cell or convert it to a formula (prefix with an equals). Hiding Data from being PrintedNeed to produce a printout where certain cells (not an entire row or column, you could right-click and Hide them) in the print area need to be hidden? One trick is to set the font colour in those cells to white.Select the cells, (Format > Cells). In the Format Cells dialog box click the Font tabClick the arrow at the right side of the Color list box and select white from the listClick OK to close the dialog box and apply your new font colour Print the worksheet without showing the unwanted cells. After you finish printing, select the cells again and set the colour back to black (or automatic). Linking a CellYou can reference a cell in another cell if you copy the cell. Adding LinksYou can copy a range of cells and paste a picture onto a worksheet. The picture is then updated automatically with any changes in values or formatting. Hold down the Shift key and select (Edit > Paste Picture Link). ImportantExcel treats numbers and text differently. Values are automatically aligned on the right and displayed in the general number format. Text is automatically aligned on the left.Copying cells will copy their values, formulas, formatting and comments. Cells cannot contain more than 32,000 characters. © 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopNextA symmetrical cell range can appear as below. The notation for this range is (A1:C6); from upper left cell A1 to bottom right cell C6. Irregular cell ranges, like in the image below, also occur. The notation for this range is (A1:C6;E2;E6;C7;C9). A cell range can be used inside a formula, for example to calculate the sum of the values within the selected cells. The notation for the sum of all values in cell range (A1:C6) is =SUM(A1:C6). Larger spreadsheets are usually stuffed with formulas based on cell ranges. When spreadsheets are edited or expanded over time, different types of range issues may occur. These issues are usually hard to detect, but they can be very risky! We’ve seen big numbers and large sums of money ‘disappear’ because of range issues. PerfectXL detects different types of range issues, like references to empty cells, interrupted formula ranges, merged cells, references to merged cells, unexpected ranges and ranges in which unexpected shifts occur. |