Monday, May 13, 2013

Numeric Details of Excel 03 and 07

Numeric Details of Excel 03 and 07



In Ms-Excel , Microsoft presenting yearly some changes in Excel

Some of the changes in Ms-Excel 2003 and 2007, i.e



Numeric Details in Excel-03 and Excel-07
Details Excel-2003 Excel-2007
Number of Rows 65536 1048576
Number of Columns 256 16384
Amount of Memory Used 1 G Bytes Maximum allowed by Windows
Number of Colors 56 4.3 Billion
Number of Conditional formats Per Cell 3 Unlimited
Number of Levels of Sorting 3 64
Number of Levels of Undo 16 100
Number of Items Shown in the Auto – Filter Dropdown 1000 10000
Number of Characters that can display in a cell 1000 32000
Number of Unique Styles in a Workbook 4000 64000
Number of Characters in a Formula 1000 8000
Number of Levels of Nesting in a Formula 7 64
Number of Function Arguments 30 255

Saturday, May 11, 2013

Excel Tricks


Some Excel Tricks :
Just type on keyboard like
=char(64)   in excel  cell..... see what happens its appears as  @
code Value
=char(33) !
=char(34) "
=char(35) #
=char(36) $
=char(37) %
=char(38) &
=char(39) '
=char(40) (
=char(41) )
=char(42) *
=char(43) +
=char(44) ,
=char(45) -
=char(46) .
=char(47) /
=char(48) 0
=char(49) 1
=char(50) 2
=char(51) 3
=char(52) 4
=char(53) 5
=char(54) 6
=char(55) 7
=char(56) 8
=char(57) 9
=char(58) :
=char(59) ;
=char(60) <
=char(61) =
=char(62) >
=char(63) ?
=char(64) @
=char(65) A
=char(66) B
=char(67) C
=char(68) D
=char(69) E
=char(70) F
=char(71) G
=char(72) H
=char(73) I
=char(74) J
=char(75) K
=char(76) L
=char(77) M
=char(78) N
=char(79) O
=char(80) P
=char(81) Q
=char(82) R
=char(83) S
=char(84) T
=char(85) U
=char(86) V
=char(87) W
=char(88) X
=char(89) Y
=char(90) Z
=char(91) [
=char(92) \
=char(93) ]
=char(94) ^
=char(95) _
=char(96) `
=char(97) a
=char(98) b
=char(99) c
=char(100) d
=char(101) e
=char(102) f
=char(103) g
=char(104) h
=char(105) i
=char(106) j
=char(107) k
=char(108) l
=char(109) m
=char(110) n
=char(111) o
=char(112) p
=char(113) q
=char(114) r
=char(115) s
=char(116) t
=char(117) u
=char(118) v
=char(119) w
=char(120) x
=char(121) y
=char(122) z
=char(123) {
=char(124) |
=char(125) }
=char(126) ~
=char(127) 
=char(128)
=char(129)
=char(130)
=char(131)
=char(132)
=char(133)
=char(134)
=char(135)
=char(136)
=char(137)
=char(138)
=char(139)
=char(140)
=char(141)
=char(142)
=char(143)
=char(144)
=char(145)
=char(146)
=char(147)
=char(148)
=char(149)
=char(150)
=char(151)
=char(152)
=char(153)
=char(154)
=char(155)
=char(156)
=char(157)
=char(158)
=char(159)
=char(160)
=char(223)
=char(224)
=char(225)
=char(226)
=char(227)
=char(228)
=char(229)
=char(230)
=char(231)
=char(243)
=char(244)
=char(245)
=char(246)
=char(247)
=char(248)
=char(249)
=char(251)
=char(252)
=char(253)