Mac prob­lems solved

Mac Format - - CONTENTS -

I’m just get­ting to grips with Num­bers af­ter nearly a (work­ing) life­time of us­ing Ex­cel. Mostly it seems quite sim­i­lar, but one thing con­tin­ues to stump me. Is there a way to change the col­umn la­bels to num­bers in­stead of let­ters? I have some spread­sheets with many hun­dreds of col­umns and this can get quite un­wieldy us­ing let­ters. Peter Mack Do you mean so that cell A1 be­comes 1,1? You can’t do that in Num­bers, nor can you do it in Ex­cel. Af­ter col­umn Z, it moves on to AA, AB, AC and so on up to AZ, then changes to AAA, AAB and so on. This is ac­tu­ally slightly more compact than us­ing num­bers be­cause you are ef­fec­tively count­ing in base 26. Col­umn AAA is num­ber 17,516.

You can of course cre­ate your own la­bels in row 1 and use th­ese in­stead. By de­fault Num­bers as­sumes that what­ever you en­ter in row 1 is the col­umn header for the rows be­low. Right-click that row and choose Freeze Header Rows so it doesn’t scroll out of view. You’ll still need to use the A1, B2 con­ven­tion to re­fer to cells in for­mu­lae, un­less you add com­plex­ity with cell lookup func­tions, but at least they’ll be la­belled to your lik­ing on screen.

Newspapers in English

Newspapers from Australia

© PressReader. All rights reserved.