Is it possible to serve up another domain's web pages from my server. The 3rd party domain will only allow my webserver ip to access certain pages. I want to put links on my server that link to these pages. The problem is that I need my server to request the page and then serve it to the user...
select the 'split box' (top of vertical scroll bar or right of the horizontal scroll bar). the cursor will turn into double vertical bars with horizontal arrows when you're on it. click and drag it to where you want. then go to window menu and select freeze panes.
or you could array enter(type in the formula and then press ctrl+shift+enter simultaneously instead of just the enter key) =IF(A1:A5,AVERAGE(A1:A5),0)and format the cell as 0;-0; to get rid of the zero. not sure how an array formula compares to four function calls efficiency-wise.
also, while...
if they're all nine digit numbers you could custom format the worksheet as '000000000'before you import. i also vaguely recall a way to do this with text to columns but i'll have to go and find it.
could you rename the new font to one of the ones already there but is never used and then try to copy it over, or is copying just a no-no no matter what?
Probably unnecesary to suggest this now that xlhelp has provided a good solution, but you could also use text to columns (data menu) and set 'space' as the delimiter.
Whatever you use, I agree with xlhelp that your gridlines disappearing is unrelated to his formula. If his suggestion of screen...
fatih
excel only allows 256 columns so you wouldn't be able to transpose any number of rows greater than that. that limitation aside, another option for transposing is to use paste special>transpose on the edit menu
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.