SOLVED

Spreadsheet :layout

%3CLINGO-SUB%20id%3D%22lingo-sub-3300807%22%20slang%3D%22en-US%22%3ESpreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300807%22%20slang%3D%22en-US%22%3E%3CP%3EI%20will%20explain%20as%20best%20I%20can.%20I%20am%20not%20expert%20in%20Excel.%20I%20have%20been%20using%20it%20for%20record%20keeping%20of%20Accounts%20Receivables%2C%20Customer%20billing%20%26amp%3B%20payments.%20I%20added%20a%20spreadsheet%20using%20%22insert%22%20and%20it%20added%20the%20sheet.%20However%2C%20the%20columns%20%22A%22%20begin%20from%20the%20right%20and%20so%20on.%20The%20Spreadsheet%20layout%20flipped%20or%20mirrored%20itself.%20I%20must%20have%20pushed%20a%20The%20spreadsheets%20I%20have%20used%20for%20record%20keeping%2C%20the%20%22A%22%20column%20starts%20from%20the%20left%20and%20so%20on.%20As%20I%20said%2C%20I%20am%20not%20well%20versed%20in%20this%20app.%20Can%20someone%20answer%20this%20question%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3300807%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3300873%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EI%20use%20%3CA%20href%3D%22https%3A%2F%2Fwww.faststone.org%2FFSCaptureDetail.htm%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFastStone%20Capture%3C%2FA%3E%20-%20I%20paid%20a%20lifetime%20license%20many%20years%20ago.%20It's%20a%20minimalist%20screen%20capture%20utility%20with%20lots%20of%20post-processing%20options%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-05-02%20233812.png%22%20style%3D%22width%3A%2070px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368675iEF32711250D9AF40%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-05-02%20233812.png%22%20alt%3D%22Screenshot%202022-05-02%20233812.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThere%20are%20free%20alternatives%2C%20such%20as%20ScreenRec%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3300839%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20did%20you%20create%20the%20red%20outline%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3300834%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300834%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F158455%22%20target%3D%22_blank%22%3E%40Ana%20Halker%20Air%20Conditioning%20Servicers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20appears%20to%20offer%20options%20both%20at%20the%20level%20of%20the%20application%20and%20the%20individual%20worksheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20639px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368666iCA44C3A1B4DE699E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3300824%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3300824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F158455%22%20target%3D%22_blank%22%3E%40Ana%20Halker%20Air%20Conditioning%20Servicers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActivate%20the%20flipped%20sheet.%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options.%3C%2FP%3E%0A%3CP%3ESelect%20Advanced%20in%20the%20navigation%20pane%20on%20the%20left.%3C%2FP%3E%0A%3CP%3EScroll%20down%20to%20the%20section%20'Display%20options%20for%20this%20worksheet'.%3C%2FP%3E%0A%3CP%3EClear%20the%20check%20box%20'Show%20sheet%20right-to-left'.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1381.png%22%20style%3D%22width%3A%20544px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368660iBFF4435B08B07262%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1381.png%22%20alt%3D%22S1381.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3380292%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3380292%22%20slang%3D%22en-US%22%3EThank%20you!%20I%20am%20so%20technology%20challenged%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3382598%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20%3Alayout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3382598%22%20slang%3D%22en-US%22%3EEveryone%20has%20to%20start%20somewhere.%20Just%20have%20confidence%20that%20you%20can%20progress.%3C%2FLINGO-BODY%3E
New Contributor

I will explain as best I can. I am not expert in Excel. I have been using it for record keeping of Accounts Receivables, Customer billing & payments. I added a spreadsheet using "insert" and it added the sheet. However, the columns "A" begin from the right and so on. The Spreadsheet layout flipped or mirrored itself. I must have pushed a The spreadsheets I have used for record keeping, the "A" column starts from the left and so on. As I said, I am not well versed in this app. Can someone answer this question? 

 

6 Replies
best response confirmed by Ana Halker Air Conditioning Servicers (New Contributor)
Solution

@Ana Halker Air Conditioning Servicers 

Activate the flipped sheet.

Select File > Options.

Select Advanced in the navigation pane on the left.

Scroll down to the section 'Display options for this worksheet'.

Clear the check box 'Show sheet right-to-left'.

Click OK.

S1381.png

@Ana Halker Air Conditioning Servicers 

Excel appears to offer options both at the level of the application and the individual worksheet.

image.png

@Hans Vogelaar 

How did you create the red outline?

@Peter Bartholomew

I use FastStone Capture - I paid a lifetime license many years ago. It's a minimalist screen capture utility with lots of post-processing options:

Screenshot 2022-05-02 233812.png

There are free alternatives, such as ScreenRec

 

Thank you! I am so technology challenged
Everyone has to start somewhere. Just have confidence that you can progress.