don't arbitrarily select the range with your mouse
put the cursor at the top (if column) or left (if row) and a little dark arrow will appear. click once and now chnage border. that will stick when you refresh.
if you cant get the arrow to appear, right click and select 'enable selection' twice.
i think you can also save such a custon view because excel still messes up these things sometimes.
There are currently 1 users browsing this thread. (0 members and 1 guests)