Remove checkboxes
Solved
Claude 1950
Posted messages
5
Registration date
Status
Membre
Last intervention
-
Sherlock Hoimes Posted messages 134 Registration date Status Membre Last intervention -
Sherlock Hoimes Posted messages 134 Registration date Status Membre Last intervention -
Hello everyone.
I received an Excel file containing checkboxes that I don't need.
Additionally, because of the column containing these checkboxes, the page is too wide when printed... Deleting the column doesn't remove the checkboxes!!!
To delete these checkboxes, I "found" a way to do it, namely: right-clicking on the checkbox, cutting (CTRL X), and so on for each checkbox... which takes a ridiculous amount of time!
Is there not a faster way to remove all the checkboxes on a page in one operation?
Thanks already for your answers.
Claude.
I received an Excel file containing checkboxes that I don't need.
Additionally, because of the column containing these checkboxes, the page is too wide when printed... Deleting the column doesn't remove the checkboxes!!!
To delete these checkboxes, I "found" a way to do it, namely: right-clicking on the checkbox, cutting (CTRL X), and so on for each checkbox... which takes a ridiculous amount of time!
Is there not a faster way to remove all the checkboxes on a page in one operation?
Thanks already for your answers.
Claude.
3 réponses
Hello
To delete, add a small icon in the ribbon that will allow you to erase all items at once (with the option to choose the items)
to add the icon in the ribbon:
Click on the OFFICE button
Click on Excel Options (at the bottom)
Click on Customize
in the pane "Choose commands from the following categories," select "commands not available on the ribbon"
search in the list for "Select multiple objects"
click on Add then OK
from there, click on this icon that has been added to the ribbon, all the objects on the sheet will be displayed, you just have to make your choice and delete?
after the operation, click on the icon again to disable it.
To delete, add a small icon in the ribbon that will allow you to erase all items at once (with the option to choose the items)
to add the icon in the ribbon:
Click on the OFFICE button
Click on Excel Options (at the bottom)
Click on Customize
in the pane "Choose commands from the following categories," select "commands not available on the ribbon"
search in the list for "Select multiple objects"
click on Add then OK
from there, click on this icon that has been added to the ribbon, all the objects on the sheet will be displayed, you just have to make your choice and delete?
after the operation, click on the icon again to disable it.
- on the sheet: F5
- click on "cells" in the bottom left of the window that just opened
- select "objects"