How to change back to A1 format because Excel is in R1C1 format by itself.

How to change back to A1 format because Excel is in R1C1 format by itself.

Have you ever opened a lot of Excel and before you know it, it’s in R1C1 format?

Both matrices are now numbers, and it’s hard to tell if it’s because they are different from usual.

Excelが勝手にR1C1形式になるのでA1形式の戻す方法

Apparently, you’ve been hanging on to other books? It seems that this can happen. (I haven’t confirmed it yet.) I’m not sure about the expression “R1C1 format”.

I don’t understand the expression “R1C1 format”… I guess it means “row” and “column” format.

To revert for now, open Excel’s options by selecting “File” – “Options”.

Uncheck “Use R1C1 reference format.

Excelが勝手にR1C1形式になるのでA1形式の戻す方法

コメント

Discover more from 株式会社CONFRAGE ITソリューション事業部

Subscribe now to keep reading and get access to the full archive.

Continue reading

Copied title and URL