Add a shape to a specific cell in Excel

0 votes

Is it possible to insert a rectangle shape into a cell within the range (A1:H4) such that the rectangle shape remains in the cell it was placed into even after the range is sorted?

3 new forms were added to the original range for Washington and Roosevelt.

enter image description here

After sorting on Name column this happens:

enter image description here

Is it possible to tie a shape to a particular cell?

Oct 24, 2022 in Others by Kithuzzz
• 27,940 points
119 views

1 answer to this question.

0 votes

When you use SORT() or data->sort on the ribbon to sort across several columns, the rows are preserved and the colours remain in place. For instance:

=SORT(A2:AH4)

Will sort those 3 rows in ID# order and keep your colors with each row as it moves.

answered Oct 24, 2022 by narikkadan
• 51,600 points

Related Questions In Others

0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 51,600 points
1,106 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 51,600 points
147 views
0 votes
1 answer
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 51,600 points
160 views
0 votes
1 answer

How to get Shape's internal name in Excel

You can reference a shape by using ...READ MORE

answered Nov 12, 2022 in Others by narikkadan
• 51,600 points
174 views
0 votes
1 answer

Using C# to find drawn arrows in Excel

There are 28 different varieties of arrow ...READ MORE

answered Dec 15, 2022 in Others by narikkadan
• 51,600 points
54 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
523 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
471 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 51,600 points
73 views
0 votes
1 answer

Activating a Specific Cell in Excel Using VBA Results to Error 400

I think you trying to select cells(4, ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 51,600 points
58 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP