36 #($''$)"Q)*1 ( - ( -
you’ve ever built a complex spreadsheet, set it
aside, and then gone back to it several weeks later
only to find you can’t remember how the spreadsheet
works or what assumptions were built into the logic,
comments may be just the thing you’re looking for. Excel
makes it easy to document the contents of any cell by
adding a comment. Here’s how to do it.
Working with Comments
/D69968DBB:CIID6CN8:AAG><=I8A>8@I=:8:AA6C98=DDH:T$CH:GI
DBB:CIU M8:AL>AA7G>C<JE6HB6AAI:MI7DMI=6I>C8AJ9:HI=:
C6B:I=6II=: M8:AHD;IL6G:>HG:<>HI:G:9ID6C9HE68:IDB6@:
68DBB:CI2=:CNDJVG:I=GDJ<=:CI:G>C<68DBB:CI8A>8@DJIH>9:
D;I=:I:MI7DM6C9 M8:AL>AA:CI:GI=:8DBB:CI>CI=:8:AA6C9
69968DBB:CI>C9>86IDGIDI=:JEE:GG><=I8DGC:GD;I=:8:AA6H
H=DLC>C!><JG:
/D H:: 6C :M>HI>C< 8DBB:CI =DK:GDK:G I=: 8:AA L>I= I=:
8DBB:CI>C9>86IDG M8:AL>AAI:BEDG6G>ANH=DLI=:8DBB:CI/D
B6@:I=:8DBB:CIH=DLL=:CNDJ6G:CVI=DK:G>C<DK:G>IG><=I
8A>8@ I=: 8:AA L>I= I=: 8DBB:CI 6C9 8=DDH: T.=DL#>9:
DBB:CIHU M8:AL>AAA:6K:I=6I8DBB:CIK>H>7A:DCI=:H8G::C
JCI>ANDJG><=I8A>8@I=:8:AA6<6>C6C98=DDH:T#>9:DBB:CIU
/D:9>I6C:M>HI>C<8DBB:CIG><=I8A>8@I=:8:AAL>I=I=:8DBB:CI
6C98=DDH:T 9>IDBB:CIU%JHIA>@:699>C<68DBB:CINDJ86C
8A>8@DJIH>9:D;I=:8DBB:CII:MI7DMID:M>II=:8DBB:CI3DJ
86C6AHDJH:I=::><=IH>O>C<7DM:HID8=6C<:I=:H=6E:D;I=:
8DBB:CII:MI7DM/D9:A:I:68DBB:CIG><=I8A>8@I=:8:AA6C9
8=DDH:T:A:I:DBB:CIU
.>B>A6G ;JC8I>DC6A>IN >H ;DJC9 DC I=: T-:K>:LU I67 >C I=:
DBB:CIHH:8I>DC6HH=DLC>C!><JG:/=:DBB:CIHH:8I>DC
>C8AJ9:H7JIIDCHIDBDK:IDI=:C:MIDGEG:K>DJH8DBB:CI6C
:6HNL6NID8N8A:I=GDJ<=6AAD;I=:8:AAHL>I=8DBB:CIH>C6
HEG:69H=::I/=:DBB:CIHH:8I>DC6AHD>C8AJ9:H67JIIDCID
T.=DL AA DBB:CIHU DC I=: LDG@H=::I /D =>9: 6AA D; I=:
8DBB:CIH8A>8@T.=DLAADBB:CIHU6<6>C!>C6AANIDH:A:8I6AA
8:AAHL>I=8DBB:CIH;GDBI=:T#DB:UI678=DDH:T!>C9.:A:8IU
6C9I=:CT"D/D.E:8>6AU/=:;>GHIDEI>DC>HDBB:CIH6HH=DLC
>C!><JG:A>8@*&IDH:A:8I6AA8:AAHL>I=8DBB:CIH
When to Use Comments
DBB:CIH6G:6<G:6IL6NID9D8JB:CIHEG:69H=::I:A:B:CIH
IDB6@:>I:6H>:G;DGNDJ6C9;DGDI=:GHIDJC9:GHI6C9NDJGHEG:69
H=::I6I6A6I:G96I:!DG:M6BEA:NDJ86CJH:8DBB:CIHID
Q D8JB:CIL=:G:6HE:8>;>8CJB7:G86B:;GDBL>I=68DBB:CI
A>@:T+:G7J9<:I-:KU
Q MEA6>CAD<>8DG6;DGBJA66H>CT/=>H8:AA699HI=:H6A6GN7DCJH
6C9I6M67A:7:C:;>I8:AAHID<:I<GDHH8DBE:CH6I>DCU
Q -:B>C9NDJGH:A;ID9DHDB:I=>C<HJ8=6HT-:B:B7:GIDJE96I:
I=:!$A>B>I:68=N:6GU
Q +DHICDI:HIDDI=:GJH:GHL=DH=6G:I=:HEG:69H=::I6H>C
T)6I:699NDJG9:E6GIB:CI=:G:U
*C: =:AE;JA ;:6IJG: D; 8DBB:CIH >H I=6I :K:C >; NDJ JH:
T.=DL#>9:DBB:CIHUID9>HEA6N8DBB:CIHI=:NINE>86AAN9DCVI
EG>CIL=:CI=:HEG:69H=::I>HEG>CI:9DBB:CIHB6@:>I:6HNID
Document Your Work with
Excel’s “Comments” Function
NEVER LOSE TRACK OF A SPREADSHEET AGAIN
By Nate Moore, CPA, MBA, CMPE
If
Comments make it easy to document the spreadsheet without
cluttering your printed final product.
Billing_Nov-Dec_14_H_Layout 1 11/7/14 12:09 PM Page 36
FIGURE 1
FIGURE 2
9D8JB:CII=:HEG:69H=::IL>I=DJI8AJII:G>C<NDJGEG>CI:9;>C6A
EGD9J8I$;NDJL6CIIDEG>CI8DBB:CIH<DIDI=:T+6<:'6NDJIUI67
6C98A>8@I=:HB6AA7JIIDC6II=:7DIIDBG><=I8DGC:GD;I=:+6<:
.:IJE6G:66HH=DLC>C!><JG:/=:G:>H6C6G:6;DG8DBB:CIH
DCI=:T.=::IUI67D;I=:+6<:.:IJEL>C9DL/=:9:;6JAI>HT)DC:U
7JINDJ86C8=DDH:TI:C9D;H=::IUIDEG>CI6AA8DBB:CIH6II=:
:C9D;6EG>CI:99D8JB:CIDGTH9>HEA6N:9DCH=::IUIDEG>CII=:
8DBB:CIH 6H I=:N 6EE:6G DC I=: LDG@H=::I C :M6BEA: D;
8DBB:CIHEG>CI:96II=::C9D;6H=::I>HH=DLC>C!><JG:
:HJG:ID<:I>CI=:=67>ID;JH>C<8DBB:CIHE6GI>8JA6GAN>C
8DBEA:MHEG:69H=::IHHEG:69H=::IHNDJ9DCVIJH:K:GND;I:CDG
>CHEG:69H=::IHNDJ8DAA67DG6I:DC;:LB>CJI:HHE:CI9D8J
B:CI>C<L>I=8DBB:CIHCDL86CB6@:NDJGHEG:69H=::IHBDG:
688JG6I:6C9H6K:=DJGHD;8DC;JH>DC9DLCI=:GD69
■
Nate Moore, CPA, MBA, FACMPE, writes custom SQL server code
to mine practice management data for analysis in Excel, on
webpages, and via email. Nate’s first book, Better Data, Better
Decisions: Using Business Intelligence in the Medical Practice,
written with Mona Reimers, was just published by MGMA. His
free Excel Videos have been viewed over 900,000 times and are
available at mooresolutionsinc.com. Like PivotTableGuy on
Facebook or follow @PivotTableGuy on Twitter to be notified each
time a new Excel Video is released.
SOFTWARE
FIGURE 3 FIGURE 4
FIGURE 5
/# %*0-)'*!/# #'/#- $''$)")()" ( )/..*$/$*) 3 7
ADVERTISE IN
Reach your target audience by
advertising in Billing. We have
multiple advertising options
available. If you are interested in
learning more, please contact:
David Merli, HBMA Sales Manager
[email protected]
202-367-1219
Billing_Nov-Dec_14_H_Layout 1 11/7/14 12:09 PM Page 37