quick filter very small (of a selected cell)
up vote
1
down vote
favorite
I work with filter in excel for a specific file… I wonder if it Is possible to increase permanently the zoom of the quick filter (working with the shorcut Alt+down) of a selected cell (without modifying the current zoom of my sheet). Indeed you can see on the picture below that the quick filter in my selected cell appears with very small words and it is not very legible…
If someone know the solution (with a macro or not), that would be really great.
Thanks in advance.
Xavi
excel vba filter
asked Nov 9 at 13:55
Xavi
346
add a comment |
up vote
1
down vote
favorite
I work with filter in excel for a specific file… I wonder if it Is possible to increase permanently the zoom of the quick filter (working with the shorcut Alt+down) of a selected cell (without modifying the current zoom of my sheet). Indeed you can see on the picture below that the quick filter in my selected cell appears with very small words and it is not very legible…
If someone know the solution (with a macro or not), that would be really great.
Thanks in advance.
Xavi
excel vba filter
asked Nov 9 at 13:55
Xavi
346
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I work with filter in excel for a specific file… I wonder if it Is possible to increase permanently the zoom of the quick filter (working with the shorcut Alt+down) of a selected cell (without modifying the current zoom of my sheet). Indeed you can see on the picture below that the quick filter in my selected cell appears with very small words and it is not very legible…
If someone know the solution (with a macro or not), that would be really great.
Thanks in advance.
Xavi
excel vba filter
asked Nov 9 at 13:55
Xavi
346
I work with filter in excel for a specific file… I wonder if it Is possible to increase permanently the zoom of the quick filter (working with the shorcut Alt+down) of a selected cell (without modifying the current zoom of my sheet). Indeed you can see on the picture below that the quick filter in my selected cell appears with very small words and it is not very legible…
If someone know the solution (with a macro or not), that would be really great.
Thanks in advance.
Xavi
excel vba filter
excel vba filter
asked Nov 9 at 13:55
Xavi
346
asked Nov 9 at 13:55
Xavi
346
asked Nov 9 at 13:55
Xavi
346
asked Nov 9 at 13:55
Xavi
346
asked Nov 9 at 13:55
Xavi
346
346
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17
add a comment |
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53227064%2fquick-filter-very-small-of-a-selected-cell%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
You can use a Combobox as an overlay, that appears when the cell with data validation is selected. Look at the Contextures site for instructions.
– Marco Vos
Nov 9 at 14:26
Lowering overall font of the sheet and zooming in would be the easier way
– Adav
Nov 9 at 14:28
thanks a lot to both of you! Finally I decided that I will process like that: first I select my cell, then Ctrl+mouse wheel (scroll up) to zoom bigger and Alt+down to get my filter inside my cell, afterward Ctrl+mouse wheel (scroll down) to zoom smaller (to come back to the normal state)...
– Xavi
Nov 9 at 17:17