•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Way to apply same formatting to all downloaded spreadsheets?
Our take
If you frequently export spreadsheets from various portals and desire consistency in formatting, you're not alone. Many users seek to streamline their workflow by applying uniform settings, such as freezing the top row, left-aligning text, and adding borders. Fortunately, there are ways to automate these formatting preferences, saving you time and effort with each download. This not only enhances your productivity but also ensures that your data remains organized and visually appealing. Explore automation options to simplify your spreadsheet management today.
When I export spreadsheets from various portals, I ALWAYS want: 1) top row frozen, 2) everything left-aligned, and 3) all borders. Is there a way to automate that so I don't have to always do that for every single damn one?
Edit: Solved!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How can I create an automation that applies a custom border to selected cells?Hello all. I just got a new job and I work in excel quite a bit. In this job, I have to download a spreadsheet and select a few cells to highlight with a custom border (just a thick red outline). I am trying to save myself time and just have a button to press (after selecting my cells) that will apply the boarder but I can't figure out how to do that. Thanks everyone for your input and have a great day! submitted by /u/Peetahbread [link] [comments]
- Exporting just one sheet?Looking for a clean way to do this. I've got a spreadsheet with multiple sheets that refence eachother for preparing data for a customer. Obviously I can just print one sheet but what I would really like to do is export the "customer" sheet as a new excel document. Ideally with some of the values becoming their data on the new sheet, but other cells keeping their formulas Example, first box would be what the cells on the export sheet output, next being their formulas. the second set would be how I would like to export, Hard coding the values as regular numbers that are referenced from a different sheet, but keeping the formulas that do math on the same sheet. Is this possible? https://preview.redd.it/cstcpxl78vqg1.png?width=181&format=png&auto=webp&s=f85a19322898ac8a3556d059ba1c5ad6dba7b867 =DifferentSheet!P7 =A1*10 =DifferentSheet!P8 =A2*10 =DifferentSheet!P9 =A3*10 https://preview.redd.it/s4xpp55h8vqg1.png?width=181&format=png&auto=webp&s=962737308118022dbc6a060481514fdc07c1e261 11.5 =A1*10 12 =A2*10 14 =A3*10 submitted by /u/223specialist [link] [comments]