Forum Discussion

Rob_Sample

Copper Contributor

Dec 07, 2023

Solved

Excel upside down text (rotated by 180 degrees)

How can I make a cell in Excel contain upside down (rotated by 180 degrees) text of another cell

excel

Excel on Mac

Formulas and Functions

djclements
Dec 08, 2023
Rob_Sample This cannot be done directly in a cell but can be faked with a "linked picture". Copy the cell that you want to be displayed upside-down, then go to Home > Paste > Linked Picture.

Paste > Linked Picture

You can then rotate the picture by going to Picture Format > Rotate. The picture will reflect any changes made to the linked cell, including applied formatting.

Linked Picture Results

djclements

Silver Contributor

Dec 08, 2023

Rob_Sample This cannot be done directly in a cell but can be faked with a "linked picture". Copy the cell that you want to be displayed upside-down, then go to Home > Paste > Linked Picture.

Paste > Linked Picture

You can then rotate the picture by going to Picture Format > Rotate. The picture will reflect any changes made to the linked cell, including applied formatting.

Linked Picture Results

Rob_Sample

Copper Contributor

Dec 09, 2023

djclements Thank you for that suggestion, that's a good solution! I had tried adding an upside down text box but had to manually copy the contents in, so this is a great improvement. I am making place cards for a club dinner from a spreadsheet of names.