Dave: /* Table Formats */ |+ Table Caption

2015-12-14T00:50:52Z

Table Formats: |+ Table Caption

Dave: Start talk page -- add table template for spreadsheet formula examples.

2015-12-13T04:34:30Z

Start talk page -- add table template for spreadsheet formula examples.

New page

== Table Formats ==
{| class="wikitable" style="color: black; background-color: #FFFAFA;"
! scope="col" |
! scope="col" | A
! scope="col" | B
! scope="col" | C
! scope="col" | D
! scope="col" | E
|-
! scope="row" style="height:25px; width:25px;" | 1
! scope="col" style="height:25px; width:70px; text-align:center; color:white; background-color: blue;" | Header 1
! scope="col" style="height:25px; width:70px; text-align:center; color:white; background-color: blue;" | Header 2
! scope="col" style="height:25px; width:70px; text-align:center; color:white; background-color: blue;" | Header 3
! scope="col" style="height:25px; width:70px; text-align:center; color:white; background-color: blue;" | Header 4
! scope="col" style="height:25px; width:70px; text-align:center; color:white; background-color: blue;" | Header 5
|-
! scope="row" style="height:25px; width:25px;" | 2
| style="text-align:center;" | 1
| style="text-align:center; background-color: orange;" | 77
| style="text-align:center;" | 4
| style="text-align:center;" | 7
| style="text-align:center;" | 10
|-
! scope="row" style="height:25px; width:25px;" | 3
| style="text-align:center;" | 2
| style="text-align:center; background-color: yellow;" | 12
| style="text-align:center;" | 5
| style="text-align:center;" | 8
| style="text-align:center;" | 11
|-
! scope="row" style="height:25px; width:25px;" | 4
| style="text-align:center;" | 3
| style="text-align:center; background-color: yellow;" | 24
| style="text-align:center;" | 6
| style="text-align:center;" | 9
| style="text-align:center;" | 12
|-
! scope="row" style="height:25px; width:25px;" | 5
| colspan="5" | '''Formula Example:'''<code></code><br />
'''Array Formula:''' The formulas shown above are [http://www.excel-easy.com/functions/array-formulas.html array formulas]. After typing an array formula into the [http://www.computerhope.com/jargon/f/formulab.htm formula bar], finish by pressing '''<tt>CTRL+Shift+Enter</tt>''' (PC) or <tt>'''CMND+Shift+Enter</tt>''' (Mac).<br />
'''Please Note:''' The formula bar indicates that this is an array formula by enclosing it in curly braces <tt>{ }</tt>. Do not type these yourself. They disappear whenever you edit the formula, making it necessary to press <tt>CTRL+Shift+Enter</tt> (PC) or <tt>CMND+Shift+Enter</tt> (Mac) whenever you edit the formula. The curly braces <tt>{ }</tt> in the examples shown above are displayed only to show what the formula looks like as it appears in the formula bar.<br />
'''Source:''' [http://www.mrexcel.com/forum/excel-questions/505622-text-numbers-same-cell-sum-numbers.html text and,numbers in same cell, sum of numbers ?]
|}

@@ Line 1: / Line 1: @@
 == Table Formats ==
 {| class="wikitable" style="color: black; background-color: #FFFAFA;"
 ! scope="col" |
 ! scope="col" | A
@@ Line 41: / Line 69: @@
 '''Please Note:''' The formula bar indicates that this is an array formula by enclosing it in curly braces <tt>{&nbsp;}</tt>. Do not type these yourself. They disappear whenever you edit the formula, making it necessary to press <tt>CTRL+Shift+Enter</tt>&nbsp;(PC) or <tt>CMND+Shift+Enter</tt>&nbsp;(Mac) whenever you edit the formula. The curly braces <tt>{&nbsp;}</tt> in the examples shown above are displayed only to show what the formula looks like as it appears in the formula bar.<br />
 '''Source:''' [http://www.mrexcel.com/forum/excel-questions/505622-text-numbers-same-cell-sum-numbers.html text and,numbers in same cell, sum of numbers ?]
 |}

Talk:Spreadsheet Tricks - Revision history

Dave: /* Table Formats */ |+ Table Caption

Dave: Start talk page -- add table template for spreadsheet formula examples.