Re: MS excel reportings, presentations, and vba helping thre
mga master paturo naman po ng katulad ng ganito https://www.youtube.com/watch?v=I0GhG_51QF8
mga master paturo naman po ng katulad ng ganito https://www.youtube.com/watch?v=I0GhG_51QF8
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Mga master paturo naman ako, regarding sa excel bording may file kasi ako pero separated sya ng mga blank cell per row.
my problem is pano siya mapapdali lagyan ng border na hindi malalagyan ng border yung mga blank cell(row).
Thanks here's my file.
[SIZE=3]1. Highlight Column B-O
2. Go to Conditional Formatting (Nasa Home Tab)
3. Select New Rule
4. Select Format only cells that contain
5. Sa Format only cells with, piliin mo No Blanks
6. Click Format
7. Select Border Tab
8. Select Outline.
9. Click Ok.
10. Click Ok.
11. Salamat.[/SIZE]
Code:[SIZE=3]1. Highlight Column B-O 2. Go to Conditional Formatting (Nasa Home Tab) 3. Select New Rule 4. Select Format only cells that contain 5. Sa Format only cells with, piliin mo No Blanks 6. Click Format 7. Select Border Tab 8. Select Outline. 9. Click Ok. 10. Click Ok. 11. Salamat.[/SIZE]
Thanks TS, applicable po ba sya sa lahat ng excel verstion?