tag:blogger.com,1999:blog-1869924468172210809.post4644138350438321031..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: You don't know what you don't know - dollar signs revisitedGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1869924468172210809.post-51843275484649328292015-04-02T10:24:56.111+01:002015-04-02T10:24:56.111+01:00There are 2 types of entering addresses of ranges:...There are 2 types of entering addresses of ranges: <br />1) typing of characters (primitive, bad),<br />2) meting out by mouse (brilliant). <br />When you mete a range out, normally Excel writes addresses without dollars, as relatives. Then you can use F4 for completing the absolute coordinates.<br />But is a difference what F4 changes: by entering it is whole range, both addresses, by following changes just the one address touched by cursor.<br />Very different behaves it in editing of noncell formulas, for example for conditioned format and for named formulas. Then is rule opposing: enters address with both dollars (absolute) and after F2 (switching editing mode: entering - changing) you change by F4 coordinates to relative ones.<br />Lubekhttps://www.blogger.com/profile/09603126614059158559noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-61987776614449419372015-03-31T18:28:24.453+01:002015-03-31T18:28:24.453+01:00Yes. I tend to do the same. Whenever I enter a ref...Yes. I tend to do the same. Whenever I enter a reference I tend to consider what should be fixed. I rarely leave it completely naked of dollars!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-27872393477690802432015-03-31T18:03:43.006+01:002015-03-31T18:03:43.006+01:00Glen--
Excellent suggestion about $ signs! They ar...Glen--<br />Excellent suggestion about $ signs! They are very valuable. And the F4 function is definitely the way to go!<br /><br />I am in the habit of using them to lock down a specific row or column (or both), even when it isn't really necessary because I'm entering the formula in only one cell (or only one row or column). I do that for three reasons: (1) You never know when you might expand the spreadsheet into additional rows and/or columns, and the absolute reference becomes really necessary; (2) It gets you into the habit of remembering about relative vs. absolute references at all times; and (3) It's just plain good spreadsheet design!Randall Boltenhttp://www.painting-with-numbers.comnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-80276710006839910572015-03-31T14:29:31.689+01:002015-03-31T14:29:31.689+01:00Pleased to be of assistance!Pleased to be of assistance!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-7980776722075676162015-03-31T14:19:43.156+01:002015-03-31T14:19:43.156+01:00Glen, you believe right (I just tried it), thanks ...Glen, you believe right (I just tried it), thanks so much. I've spent the best part of 2 years having to enter $ manually, that is going to save me so much time!!!!BigBlokehttps://www.blogger.com/profile/08546172103776361975noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-47768516962390538732015-03-31T13:48:36.933+01:002015-03-31T13:48:36.933+01:00I don't use a Mac myself, but I believe that C...I don't use a Mac myself, but I believe that CMD-t does the same thing.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-12642468398967611512015-03-31T13:45:06.653+01:002015-03-31T13:45:06.653+01:00Glen, a good post. I've used F4 for many years...Glen, a good post. I've used F4 for many years but found that this doesn't work on Excel for Mac and despite much experimentation I haven't found a equivalent - I miss it so much when I'm working on my MacBook!!!!BigBlokehttps://www.blogger.com/profile/08546172103776361975noreply@blogger.com