Forum Discussion
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
Its better to have an identity column or a column with a Primary key.
Identity Column -> In SQL Server, an identity column is a special type of column that is commonly used as the primary key of a table. An identity column is a column whose values are generated automatically by the database system, typically incrementing by 1 for each new row added to the table. The purpose of an identity column is to provide a unique, sequential number for each row in the table.
Example -
CREATE TABLE my_table (
id INT IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(50),
age INT
);Update Statement -
UPDATE my_table
SET my_column = 'new_value'
WHERE my_column = 'old_value';You can manually update the same via GUI as well.
Hope it's clear------- If yes, reply and hit like ----- If not reply with your query in more detail----
2 Replies
- djclementsBronze Contributor
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_SampleCopper Contributordjclements 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.