This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
Thanks for looking at this. Appreciate all feedback both specific and general.
If there are any VBA champions here that might be what is needed or maybe more advanced functions.
I have formatted general things for my table, colours, conditional formatting, font size, but wanting a few more behavioral tweaks.
This sheet/table is currently shared via One Drive in a company environment.
Sheet linked to here is simplified version with some things missing.
My wish list:
Position horizontal scrollbar to the left when sheet is opened in a browser tab or window, so the whole table shows.
Set default sheet zoom to 90% when first opened in browser (each time its opened in a new window or another tab in the browser) but allow adjusting after that initial load in the browser (not a locked attribute),
Date formatting to be Australian English region, 25/10/2023
DD/MM/YYYY force this format on all views if possible.
Block end user from shrinking table (removing rows). (I believe not allowing editing in sharing would cover this).
Block end user from Deleting rows or columns. (I believe not allowing editing in sharing would cover this).
In terms of field header, and column formatting.
* All columns have wrap text on.
* All column body text/data are size 10 font century gothic except where stated here.
* These settings are set up in the attached sheet, but I want to Bake them in (fixed formatting).
And as per the sheet sample are a mix of either center/middle aligned, or left/middle aligned.
If new data is being pasted into the cells, this sheets formatting should override the formatting from the data being pasted in from another sheet. Data types should remain fixed and non editable.
| First contact and last contact headers<br><br>Header only: middle aligned to left. <br><br>Size 9 font.<br><br><br><br>Data type: date English (Australian) | - Column body text: size 9 font.<br><br>- Alignment; bottom align to right.<br><br><br><br>- English (Australian) format. date. |
|---|---|
| Job no. and dispatch headers<br><br>Header only: middle aligned to left. <br><br>Size 9 font<br><br><br><br>Data type: general. (not 'number' as there is some text involved). | - Column body text: size 8 font.<br><br>- Alignment: Bottom aligned and centered text. |
| Pending issue, response, and admin notes headers<br><br>Header only : middle align and centered. <br><br>Size 11 font.<br><br><br><br>Data type: text | - Column body text: size 10 font.<br><br>- Alignment: to Top, and to Left side margin.<br><br><br><br>- Font exception. user can apply BOLD and UNDERLINE, but not change font type or font size in columns.<br><br><br><br>- All cells in these 3 columns will add 1 extra line space at bottom of the cell when Enter is pressed to exit the cell.<br><br>*1* see graphic below table.<br><br><br><br>- Cell will always show all text entered. (Therefore the height of the specific row will be determined by which cell from these 3 headers has the most text, but if the cells are empty, fill with 3 blank lines spacing in the cell.<br><br><br><br>If that is too complicated, maintain visibility of other column cells. Meaning "first contact", "job no", "dispatch" cell data should be at least visible. (which would generally be 1 or 2 lines). |
| Status header<br><br>Header and column cells: middle align and centered.<br><br>Size 11 font.<br><br><br><br>Data type: text | Has own conditional formatting in the sheet.<br><br>I want this fixed/not editable by end user. |
| Body cell borders (not the headers).<br><br>no data type. | Apply to body cells, not headers.<br><br>As per the grey lines applied. (see sheet attached). |
| Agent header<br><br>Header only: Center and middle aligned. <br><br>Size 11 font.<br><br><br><br>Data type: text | - Column body text. font size: 10<br><br>- Alignment: Bottom and left aligned. |
| Site header<br><br>Header only: Center and middle aligned.<br><br>size 11 font<br><br><br><br>Data type: text | - Column body text: font size: 10<br><br>- alignment: Top and Left aligned |
| Issue header<br><br>Header only: middle and left aligned.<br><br>Size 11 font. | This will be a drop down menu option which will be fixed.<br><br>(not supplied here as yet).<br><br><br><br>- Column text: font size: 10<br><br>- alignment: Bottom and Left aligned |
*1* from table.
Left and top aligned with 1 line space at bottom of cell for body text in pending issue, response, admin notes and Sites columns.
Thanks for any advice, direction or assistance, really appreciate it.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Set default sheet zoom to 90% when first opened in browser
I guess impossible.
Why you need this default view in browser?
If you want specific view in browser,I guess you need a .html file rather than .xlsx file.
thank you I will post there
Hello EagleMoxy,
Thank you for writing us here in Microsoft Community.
It seems best to post this same question to Microsoft Excel Community Welcome to the Excel Community - Microsoft Community Hub and Microsoft Q&A Questions - Microsoft Q&A to get accurate answers from Excel experts for you to be guided accordingly on how to achieve your goals. You may as well check expert answers from posts that have similar inquiry.
We will leave this thread open for our MVPs or other members who are experts about this concern to share their answers.
Yours truly,
Bryll
Microsoft Community Agent